[
https://issues.apache.org/jira/browse/IMPALA-9326?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong resolved IMPALA-9326.
-----------------------------------
Resolution: Duplicate
This was fixed as part of IMPALA-8800.
> 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
> Components: Frontend
> Reporter: Vladimir Verjovkin
> Priority: Major
> Labels: kudu, ramp-up
>
> 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)
