[IMPALA-11254] Create Kudu table with hash + range partitions fails

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: Impala 4.0.0
• Component/s: Frontend
• Epic Color: ghx-label-1
• Assignee: Unassigned
• Reporter: Manish Maheshwari
• Created: 20/Apr/22 03:56
• Updated: 21/Apr/22 01:17

Description

The below query fails -

CREATE TABLE lsr (
end_time TIMESTAMP,
uuid String,
start_m_tmsi bigint,
start_time TIMESTAMP,
duration TIMESTAMP,
partition_date date,
PRIMARY KEY(end_time, uuid) 
) 
PARTITION BY RANGE (end_time)
(
PARTITION VALUES < '2011-09-01',
PARTITION '2011-09-01' <= VALUES < '2011-10-01',
PARTITION '2011-10-01' <= VALUES < '2011-11-01',
PARTITION '2011-11-01' <= VALUES
), 
HASH (uuid) PARTITIONS 5
STORED AS KUDU ;
 

If you swap the order of range and hash partitions, it works.