Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
Impala 2.9.0
-
ghx-label-1
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.