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

CTAS for Kudu table and expr rewrite analysis exception

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment