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)