Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5796

CTAS for Kudu table and expr rewrite analysis exception

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Critical
    • Resolution: Fixed
    • Impala 2.9.0
    • Impala 2.10.0
    • Frontend

    Description

      Creating a Kudu table with a CTAS query containing a WITH clause seems to be broken:

      CREATE TABLE not_ok_1
      PRIMARY KEY (int_col)
      PARTITION BY HASH (int_col) PARTITIONS 4
      stored as kudu
      AS with src as (SELECT distinct int_col
      FROM functional.alltypes
      where int_col between 5 and 10)
      select * from src;
      
      ERROR: AnalysisException: Multiple primary keys specified. Composite primary keys can be specified using the PRIMARY KEY (col1, col2, ...) syntax at the end of the column definition.
      

      I don't think we have any existing tests for CTAS into Kudu tables containing WITH clauses, so I'm not surprised that path is broken.

      Attachments

        Activity

          People

            twmarshall Thomas Tauber-Marshall
            mjacobs Matthew Jacobs
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: