[IMPALA-9927] Create table fails if PK constraint defined on partition column

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: Impala 3.4.0
• Component/s: Frontend
• Epic Color: ghx-label-9
• Assignee: Unassigned
• Reporter: David Rorke
• Created: 08/Jul/20 17:40
• Updated: 08/Jul/20 17:40

Description

Create table doesn't allow you to specify a primary key that's a partition column:

Query: create table mytable
(
  i1 int,
  i2 int,
  primary key (i3) DISABLE NOVALIDATE RELY
)
partitioned by (i3 int)
stored as parquet
ERROR: AnalysisException: PRIMARY KEY column 'i3' does not exist in the table