[
https://issues.apache.org/jira/browse/SPARK-32603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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: [email protected]
For additional commands, e-mail: [email protected]
