Dan Burkert created IMPALA-6929:
-----------------------------------

             Summary: Create Kudu table syntax does not allow multi-column 
range partitions
                 Key: IMPALA-6929
                 URL: https://issues.apache.org/jira/browse/IMPALA-6929
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 2.11.0
            Reporter: Dan Burkert


The Impala CREATE TABLE syntax guide includes this bit of grammar in the Kudu 
partitioning section:
{code:java}
range_clause ::=
  RANGE [ (pk_col [, ...]) ]
  (
    {
      PARTITION constant_expression range_comparison_operator VALUES 
range_comparison_operator constant_expression
      | PARTITION VALUE = constant_expression_or_tuple
    }
   [, ...]
  ){code}
This is suspicious because {{constant_expression}} is used in the range clause, 
and {{constant_expression_or_tuple}} is used in the single-value clause.  I 
believe both should allow for tuples.

In other words, today a CREATE TABLE statement such as
{code:java}
CREATE TABLE t (a BIGINT, b BIGINT, PRIMARY KEY (a, b))
PARTITION BY RANGE (a, b) (
    PARTITION (0, 0) <= VALUES < (10, 0)
) STORED AS KUDU;{code}
results in a syntax error, and it should not.  CC [~twmarshall]



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to