[jira] [Created] (IMPALA-11809) Support non unique primary key for Kudu

["Wenzhe Zhou (Jira)" <ji...@apache.org>]

Wenzhe Zhou created IMPALA-11809:
------------------------------------

             Summary: Support non unique primary key for Kudu
                 Key: IMPALA-11809
                 URL: https://issues.apache.org/jira/browse/IMPALA-11809
             Project: IMPALA
          Issue Type: New Feature
          Components: Backend, Catalog, Frontend
    Affects Versions: Impala 4.3.0
            Reporter: Wenzhe Zhou


Kudu engine adds support for non unique primary key. It adds a column 'auto_increment_id' automatically in a table which has non unique primary key. The non unique primary key and 'auto_increment_id' form unique composite primary key for the table.

Impala need to add syntactic support for creating Kudu table with non unique primary key like:
  CREATE TABLE tbl (i INT NON UNIQUE PRIMARY KEY, s STRING)
  PARTITION BY HASH (i) partitions 3
  STORED as KUDU;
  
 CREATE TABLE tbl (i INT, s STRING, NON UNIQUE PRIMARY KEY(i))
  PARTITION BY HASH (i) partitions 3
  STORED as KUDU;
  
  CREATE TABLE tbl NON UNIQUE PRIMARY KEY(id)
  PARTITION BY HASH (id) partitions 3
  STORED as KUDU
  AS SELECT id, string_col FROM functional.alltypes WHERE id = 10;




--
This message was sent by Atlassian Jira
(v8.20.10#820010)