[jira] [Commented] (SPARK-32603) CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers

2020-11-30 Thread Huaxin Gao (Jira) 


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

Huaxin Gao commented on SPARK-32603:


Tests have been updated in https://github.com/apache/spark/pull/30544. I will 
close this ticket.

> CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers
> -
>
> Key: SPARK-32603
> URL: https://issues.apache.org/jira/browse/SPARK-32603
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.1.0
>Reporter: Huaxin Gao
>Priority: Major
>
> {code:java}
> == SQL ==
> CREATE TABLE h2.test.abc AS SELECT * FROM h2.test.people
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> Operation not allowed: CREATE TABLE ... STORED AS ... does not support 
> multi-part identifiers
> {code}
> {code:java}
> == SQL ==
> CREATE OR REPLACE TABLE h2.test.abc AS SELECT 1 as col
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> mismatched input 'AS' expecting {'(', 'USING'}
> {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

[jira] [Commented] (SPARK-32603) CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers

2020-11-30 Thread Wenchen Fan (Jira) 


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

Wenchen Fan commented on SPARK-32603:
-

CREATE TABLE unification PR is merged. [~huaxingao] can you update the tests 
and resolve this ticket? Thanks!

> CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers
> -
>
> Key: SPARK-32603
> URL: https://issues.apache.org/jira/browse/SPARK-32603
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.1.0
>Reporter: Huaxin Gao
>Priority: Major
>
> {code:java}
> == SQL ==
> CREATE TABLE h2.test.abc AS SELECT * FROM h2.test.people
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> Operation not allowed: CREATE TABLE ... STORED AS ... does not support 
> multi-part identifiers
> {code}
> {code:java}
> == SQL ==
> CREATE OR REPLACE TABLE h2.test.abc AS SELECT 1 as col
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> mismatched input 'AS' expecting {'(', 'USING'}
> {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

[jira] [Commented] (SPARK-32603) CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers

2020-09-07 Thread Huaxin Gao (Jira) 


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

Huaxin Gao commented on SPARK-32603:


I thought CREATE TABLE syntax will be unified for hive and datasource? Anyway, 
I opened this ticket to track the problems I hit when testing V2 JDBC. If in 
the future we decide not to support this syntax, I will close this jira. 

> CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers
> -
>
> Key: SPARK-32603
> URL: https://issues.apache.org/jira/browse/SPARK-32603
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.1.0
>Reporter: Huaxin Gao
>Priority: Major
>
> {code:java}
> == SQL ==
> CREATE TABLE h2.test.abc AS SELECT * FROM h2.test.people
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> Operation not allowed: CREATE TABLE ... STORED AS ... does not support 
> multi-part identifiers
> {code}
> {code:java}
> == SQL ==
> CREATE OR REPLACE TABLE h2.test.abc AS SELECT 1 as col
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> mismatched input 'AS' expecting {'(', 'USING'}
> {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

[jira] [Commented] (SPARK-32603) CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers

2020-09-03 Thread angerszhu (Jira) 


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

angerszhu commented on SPARK-32603:
---

In current grammar
{code:java}
| replaceTableHeader ('(' colTypeList ')')? tableProvider
createTableClauses
(AS? query)?   #replaceTable
| createTableHeader ('(' colTypeList ')')? tableProvider
createTableClauses
(AS? query)?   #createTable
| createTableHeader ('(' columns=colTypeList ')')?
(commentSpec |
(PARTITIONED BY '(' partitionColumns=colTypeList ')' |
PARTITIONED BY partitionColumnNames=identifierList) |
bucketSpec |
skewSpec |
rowFormat |
createFileFormat |
locationSpec |
(TBLPROPERTIES tableProps=tablePropertyList))*
(AS? query)?   
#createHiveTable
{code}
without tableProvider (USING xxx), will be defined as hive 's way.  
Implementing `support the syntax without USING _.` doesn't make much sense.

 

 

> CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers
> -
>
> Key: SPARK-32603
> URL: https://issues.apache.org/jira/browse/SPARK-32603
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.1.0
>Reporter: Huaxin Gao
>Priority: Major
>
> {code:java}
> == SQL ==
> CREATE TABLE h2.test.abc AS SELECT * FROM h2.test.people
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> Operation not allowed: CREATE TABLE ... STORED AS ... does not support 
> multi-part identifiers
> {code}
> {code:java}
> == SQL ==
> CREATE OR REPLACE TABLE h2.test.abc AS SELECT 1 as col
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> mismatched input 'AS' expecting {'(', 'USING'}
> {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

[jira] [Commented] (SPARK-32603) CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers

2020-09-03 Thread Huaxin Gao (Jira) 


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

Huaxin Gao commented on SPARK-32603:


[~angerszhuuu]
I opened this ticket when working on this PR 
https://github.com/apache/spark/pull/29396. I currently get around the problems 
using 

{code:java}
CREATE TABLE h2.test.abc USING _ AS SELECT * FROM h2.test.people
CREATE OR REPLACE TABLE h2.test.abc USING _ AS SELECT 1 as col
{code}
but seems to me that we eventually need to support the syntax without USING _.






> CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers
> -
>
> Key: SPARK-32603
> URL: https://issues.apache.org/jira/browse/SPARK-32603
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.1.0
>Reporter: Huaxin Gao
>Priority: Major
>
> {code:java}
> == SQL ==
> CREATE TABLE h2.test.abc AS SELECT * FROM h2.test.people
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> Operation not allowed: CREATE TABLE ... STORED AS ... does not support 
> multi-part identifiers
> {code}
> {code:java}
> == SQL ==
> CREATE OR REPLACE TABLE h2.test.abc AS SELECT 1 as col
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> mismatched input 'AS' expecting {'(', 'USING'}
> {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

[jira] [Commented] (SPARK-32603) CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers

2020-09-03 Thread angerszhu (Jira) 


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

angerszhu commented on SPARK-32603:
---

| replaceTableHeader ('(' colTypeList ')')? tableProvider
 createTableClauses
 (AS? query)?

 

Second SQL wrong for current grammar

> CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers
> -
>
> Key: SPARK-32603
> URL: https://issues.apache.org/jira/browse/SPARK-32603
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.1.0
>Reporter: Huaxin Gao
>Priority: Major
>
> {code:java}
> == SQL ==
> CREATE TABLE h2.test.abc AS SELECT * FROM h2.test.people
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> Operation not allowed: CREATE TABLE ... STORED AS ... does not support 
> multi-part identifiers
> {code}
> {code:java}
> == SQL ==
> CREATE OR REPLACE TABLE h2.test.abc AS SELECT 1 as col
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> mismatched input 'AS' expecting {'(', 'USING'}
> {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

[jira] [Commented] (SPARK-32603) CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers

2020-09-03 Thread angerszhu (Jira) 


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

angerszhu commented on SPARK-32603:
---

[~huaxingao] Since in current mode, seem we only can connect to one 
HiveMetaStore, so, it don't support multi catalog and throw exception. In our 
env we use extension to support spark connect to multi hive metastore with 
different catalog name

> CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers
> -
>
> Key: SPARK-32603
> URL: https://issues.apache.org/jira/browse/SPARK-32603
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.1.0
>Reporter: Huaxin Gao
>Priority: Major
>
> {code:java}
> == SQL ==
> CREATE TABLE h2.test.abc AS SELECT * FROM h2.test.people
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> Operation not allowed: CREATE TABLE ... STORED AS ... does not support 
> multi-part identifiers
> {code}
> {code:java}
> == SQL ==
> CREATE OR REPLACE TABLE h2.test.abc AS SELECT 1 as col
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> mismatched input 'AS' expecting {'(', 'USING'}
> {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

[jira] [Commented] (SPARK-32603) CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers

2020-08-12 Thread Huaxin Gao (Jira) 


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

Huaxin Gao commented on SPARK-32603:


cc [~maxgekk]

> CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers
> -
>
> Key: SPARK-32603
> URL: https://issues.apache.org/jira/browse/SPARK-32603
> Project: Spark
>  Issue Type: Sub-task
>  Components: SQL
>Affects Versions: 3.1.0
>Reporter: Huaxin Gao
>Priority: Major
>
> {code:java}
> == SQL ==
> CREATE TABLE h2.test.abc AS SELECT * FROM h2.test.people
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> Operation not allowed: CREATE TABLE ... STORED AS ... does not support 
> multi-part identifiers
> {code}
> {code:java}
> == SQL ==
> CREATE OR REPLACE TABLE h2.test.abc AS SELECT 1 as col
> ^^^
> org.apache.spark.sql.catalyst.parser.ParseException: 
> mismatched input 'AS' expecting {'(', 'USING'}
> {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