[IMPALA-9326] PARTITION BY RANGE clause does not accept DATE constants

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Component/s: Frontend
• Labels: kudu ramp-up
• Epic Color: ghx-label-10
• Assignee: Unassigned
• Reporter: Vladimir Verjovkin
• Created: 24/Jan/20 05:11
• Updated: 22/Dec/20 20:48
• Resolved: 22/Dec/20 20:48

Description

In impala-shell.sh, when I submit DDL command

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;

it's succeeds.

When I submit command:

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;

or

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;

or

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;

it fails with message:

ERROR: IllegalStateException: null

Issue Links

• duplicates: IMPALA-8800 Add DATE type support to Kudu scanner