Manish Maheshwari created IMPALA-11254:
------------------------------------------

             Summary: Create Kudu table with range+hash partitions fails
                 Key: IMPALA-11254
                 URL: https://issues.apache.org/jira/browse/IMPALA-11254
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 4.0.0
            Reporter: Manish Maheshwari


The below query fails -
{code:java}
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 ;
 {code}
If you swap the order of range and hash partitions, it works.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to