You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "David Rorke (Jira)" <ji...@apache.org> on 2020/07/08 17:41:00 UTC
[jira] [Created] (IMPALA-9927) Create table fails if PK constraint
defined on partition column
David Rorke created IMPALA-9927:
-----------------------------------
Summary: Create table fails if PK constraint defined on partition column
Key: IMPALA-9927
URL: https://issues.apache.org/jira/browse/IMPALA-9927
Project: IMPALA
Issue Type: Bug
Components: Frontend
Affects Versions: Impala 3.4.0
Reporter: David Rorke
Create table doesn't allow you to specify a primary key that's a partition column:
{noformat}
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
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)