Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-24907 Migrate JDBC data source to DataSource API v2
  3. SPARK-32603

CREATE/REPLACE TABLE AS SELECT not support multi-part identifiers

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • 3.1.0
    • None
    • SQL
    • None

    Description

      == 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
      
      == 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'}
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            huaxingao Huaxin Gao
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: