[ https://issues.apache.org/jira/browse/IMPALA-11906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wenzhe Zhou resolved IMPALA-11906. ---------------------------------- Fix Version/s: Impala 4.3.0 Resolution: Fixed > Impala Doc: Support non unique primary key for Kudu table > --------------------------------------------------------- > > Key: IMPALA-11906 > URL: https://issues.apache.org/jira/browse/IMPALA-11906 > Project: IMPALA > Issue Type: Documentation > Components: Docs > Affects Versions: Impala 4.3.0 > Reporter: Wenzhe Zhou > Assignee: shajini thayasingh > Priority: Major > Labels: documentation > Fix For: Impala 4.3.0 > > > IMPALA-11809 Added support non unique primary key for Kudu table. We should > document the syntax for non unique primary key. > - We added syntactic support for creating Kudu table with non unique primary > key. > For example: > CREATE TABLE tbl (id INT NON UNIQUE PRIMARY KEY, name STRING) > PARTITION BY HASH (id) PARTITIONS 3 > STORED as KUDU; > More samples could be found in the commit messages of > https://issues.apache.org/jira/browse/IMPALA-11809 > - Kudu engine appends a system generated auto-incrementing column to the non > unique primary key columns to guarantee the uniqueness on primary key. This > auto-incrementing column is named as 'auto_incrementing_id' with bigint type. > The assignment to it during insertion is automatic. > 'auto_incrementing_id' column cannot be added, removed or renamed with ALTER > TABLE statements. > - When creating a Kudu table, specifying PRIMARY KEY is optional now. If > there is no primary key attribute specified, the partition key columns could > be promoted as non unique primary key if those columns are the beginning > columns of the table. > In following sample, 'a' and 'b' will be promoted as non unique primary key, > 'auto_incrementing_id' column will be added by Kudu engine. 'a', 'b' and > 'auto_incrementing_id' form the effective unique composite primary key. > CREATE TABLE tbl (a INT, b STRING, c FLOAT) > PARTITION BY HASH (a, b) PARTITIONS 3 > STORED as KUDU; > - New column "key_unique" is added to the output of 'describe' table command > for Kudu table, which shows if the primary key is unique. > - SELECT statement does not show the system generated auto-incrementing > column unless the column is explicitly specified in the select list. > - UPSERT operation is not supported for Kudu tables with non unique primary > key. -- This message was sent by Atlassian Jira (v8.20.10#820010) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org