Hi, I have a simple table with range partitions defined by upper and lower bounds. CREATE TABLE work.sales_by_year ( year INT, sale_id INT, amount INT, PRIMARY KEY (sale_id, year) ) PARTITION BY RANGE (year) ( PARTITION VALUES < 2015, PARTITION 2015 <= VALUES < 2016, PARTITION 2016 <= VALUES ) STORED AS KUDU; So this table has three partitions: +--------+-----------+----------+-------------------------------------------------+------------+ | # Rows | Start Key | Stop Key | Leader Replica | # Replicas | +--------+-----------+----------+-------------------------------------------------+------------+ | -1 | 800007DF | host1:7050 | 3 | | -1 | 800007DF | 800007E0 | host2:7050 | 3 | | -1 | 800007E0 | | host3:7050 | 3 | +--------+-----------+----------+-------------------------------------------------+------------+ Now I would like to end the last range with 2017 and have another interval for values >= 2017. I tried multiple syntaxes, but it does not work: alter table work.sales_by_year add range partition 2016 <= VALUES < 2017;
Query: alter table work.sales_by_year add range partition 2016 <= VALUES < 2017
ERROR: ImpalaRuntimeException: Error adding range partition in table sales_by_year
CAUSED BY: NonRecoverableException: New range partition conflicts with existing range partition: 2016 <= VALUES < 2017 alter table work.sales_by_year add range partition VALUE = 2017;
Query: alter table work.sales_by_year add range partition VALUE = 2017
ERROR: ImpalaRuntimeException: Error adding range partition in table sales_by_year
CAUSED BY: NonRecoverableException: New range partition conflicts with existing range partition: 2017 <= VALUES < 2018 These error messages are misleading, if I run show partitions, I am having still those three intervals, so no 2017 and 2018. Any hints how to extend the range partitons? Thanks
... View more
