[ 
https://issues.apache.org/jira/browse/SPARK-32427?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17171020#comment-17171020
 ] 

Huaxin Gao commented on SPARK-32427:
------------------------------------

[~maxgekk]
I made the tableProvider to be optional to omit USING, but now it seems the 
CREATE TABLE SYNTAX has ambiguity. For example, the following CREATE TABLE is 
supposed to create a Hive table, but after my change it creates a data source 
table.

{code:java}
        s"""CREATE TABLE t1 (
           |  c1 INT COMMENT 'bla',
           |  c2 STRING
           |)
           |TBLPROPERTIES (
           |  'prop1' = 'value1',
           |  'prop2' = 'value2'
           |)
         """.stripMargin
{code}


> Omit USING in CREATE TABLE via JDBC Table Catalog
> -------------------------------------------------
>
>                 Key: SPARK-32427
>                 URL: https://issues.apache.org/jira/browse/SPARK-32427
>             Project: Spark
>          Issue Type: Sub-task
>          Components: SQL
>    Affects Versions: 3.1.0
>            Reporter: Maxim Gekk
>            Priority: Major
>
> Support creating tables in JDBC Table Catalog without USING, for instance:
> {code:sql}
> CREATE TABLE h2.test.new_table(i INT, j STRING)
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to