Error drop_partitions forceSplit
nandreev93
Community Edition User
Hello
When I executed drop_partitions function Vertica returns an error:ERROR 55000 ERROR 8430: Some storage containers must be split before the specified partition range can be dropped HINT: Set "forceSplit" to true to implicitly repartition the data
Command that is executed is as follows:select drop_partitions('ods.table_name','2019-01-01','2019-01-01','true');
So forceSplit is already set to true. Table is partitioned hierarchicaly (year - month - day) and I get the error when I am trying to drop partition from inactive months/years , maybe this somehow affecting.
Almost the same error I get when using swap_partition_between_tables function.
What can cause the problem? And how can I fix it?
0
Comments
Hello,
We have the same issue on Vertica Analytic Database v9.2.1-2.
What's the root cause? How to fix the issue?
Damien.
Hello, the same problem with 9.2.1. Someone found the solution?
I have the same problem in 9.3.1-7
In version v9.3.1-0 , I don't see the problem.
My partitioning on sample schema table looks like below:
Hierarchical Partition distribution is like below:
Now I'll drop 2012-02-01 partition below:
Note the 9 Partition keys sitting in separate ROS container.
Ran the MERGEOUT...
Let's DROP some more partition keys...
ALL Clean !
Can you please share the details?
Version and Step-by-Step to recreate the problem?
Also please include the relevant out-put of query from partitions tables.
Thanks
As a follow-up...