You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "angerszhu (Jira)" <ji...@apache.org> on 2020/09/03 07:25:00 UTC
[jira] [Commented] (SPARK-32603) CREATE/REPLACE TABLE AS SELECT not
support multi-part identifiers
[ 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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org