[IMPALA-5546] Add syntax for creating an unpartitioned kudu table

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.8.0
• Fix Version/s: Impala 2.10.0
• Component/s: Frontend
• Labels: kudu
• Target Version: Impala 2.10.0
• Epic Color: ghx-label-8
• Assignee: Thomas Tauber-Marshall
• Reporter: Matthew Jacobs
• Created: 20/Jun/17 18:30
• Updated: 10/Nov/17 00:44
• Resolved: 07/Aug/17 22:19

Description

It is currently difficult to create a Kudu table with a single partition, but this is useful for very small tables. It's currently possible to do so by creating one range partition that spans the entire key range, but this is very cumbersome. We should add syntax to make this easier. Internally to Kudu we would represent this as range partitioning over no columns.

Current syntax:

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name
  (col_name data_type
    [kudu_column_attribute ...]
    [COMMENT 'col_comment']
    [, ...]
    [PRIMARY KEY (col_name[, ...])]
  )
  [PARTITION BY kudu_partition_clause
  [COMMENT 'table_comment']
  STORED AS KUDU
  [TBLPROPERTIES ('key1'='value1', 'key2'='value2', ...)]

Proposed syntax:

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name
  (col_name data_type
    [kudu_column_attribute ...]
    [COMMENT 'col_comment']
    [, ...]
    [PRIMARY KEY (col_name[, ...])]
  )
  [UNPARTITIONED | PARTITION BY kudu_partition_clause
  [COMMENT 'table_comment']
  STORED AS KUDU
  [TBLPROPERTIES ('key1'='value1', 'key2'='value2', ...)]

Issue Links

• breaks: IMPALA-6173 SHOW CREATE TABLE broken for unpartitioned Kudu tables