Huaxin Gao created SPARK-32603:
----------------------------------

             Summary: 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



{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]

Reply via email to