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)