Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-5546

Add syntax for creating an unpartitioned kudu table

    Details

    • 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:

      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', ...)]
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                twmarshall Thomas Tauber-Marshall
                Reporter:
                mjacobs Matthew Jacobs
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: