You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Thomas Tauber-Marshall (JIRA)" <ji...@apache.org> on 2018/06/13 19:49:00 UTC

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

     [ https://issues.apache.org/jira/browse/IMPALA-6929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Tauber-Marshall resolved IMPALA-6929.
--------------------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 3.1.0
                   Impala 2.13.0

> 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
>            Assignee: Thomas Tauber-Marshall
>            Priority: Major
>             Fix For: Impala 2.13.0, Impala 3.1.0
>
>
> 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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org