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

CTAS for Kudu table and expr rewrite analysis exception

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: Impala 2.9.0
    • Fix Version/s: Impala 2.10.0
    • Component/s: Frontend
    • Labels:

      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

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

              Dates

              • Created:
                Updated:
                Resolved: