impala-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matthew Jacobs (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IMPALA-5546) Add syntax for creating an unpartitioned kudu table
Date Tue, 20 Jun 2017 18:31:00 GMT
Matthew Jacobs created IMPALA-5546:
--------------------------------------

             Summary: Add syntax for creating an unpartitioned kudu table
                 Key: IMPALA-5546
                 URL: https://issues.apache.org/jira/browse/IMPALA-5546
             Project: IMPALA
          Issue Type: New Feature
          Components: Frontend
    Affects Versions: Impala 2.8.0
            Reporter: Matthew Jacobs


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:
{code}
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', ...)]
{code}

Proposed syntax:
{code}
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', ...)]
{code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message