[jira] [Created] (IMPALA-6929) Create Kudu table syntax does not allow multi-column range partitions

["Dan Burkert (JIRA)" <ji...@apache.org>]

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)