[ 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