You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@impala.apache.org by "Vladimir Verjovkin (Jira)" <ji...@apache.org> on 2020/01/24 05:12:00 UTC

[jira] [Created] (IMPALA-9326) PARTITION BY RANGE clause does not accept DATE constants

Vladimir Verjovkin created IMPALA-9326:
------------------------------------------

             Summary: PARTITION BY RANGE clause does not accept DATE constants
                 Key: IMPALA-9326
                 URL: https://issues.apache.org/jira/browse/IMPALA-9326
             Project: IMPALA
          Issue Type: Improvement
            Reporter: Vladimir Verjovkin


In impala-shell.sh, when I submit DDL command
{code:java}
create table kudu_partition_test3 (ts TIMESTAMP, primary key(ts))
partition by range (ts) 
( partition '2018-05-01' <= values < '2018-06-01') stored as kudu;{code}
it's succeeds.

When I submit command:
{code:java}
create table kudu_partition_test4 (ts DATE, primary key(ts))
partition by range (ts) 
( partition '2018-05-01' <= values < '2018-06-01') stored as kudu;{code}
or
{code:java}
create table kudu_partition_test5 (ts DATE, primary key(ts))
partition by range (ts) 
( partition to_date('2018-05-01') <= values < to_date('2018-06-01')) stored as kudu;{code}
or
{code:java}
create table kudu_partition_test6 (ts DATE, primary key(ts))
partition by range (ts) 
( partition date '2018-05-01' <= values < date '2018-06-01') stored as kudu;{code}
it fails with message:
{code:java}
ERROR: IllegalStateException: null{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)