I am trying to split an existing table into a year (no existing partitions)
alter table test_table PARTITION BY EXTRACT (year FROM date_c);
But there seems to be some mistake
ROLLBACK 2628: The column "date_c" in the PARTITION BY clause is not valid because it contains NULL ** TIP. If the column does not currently contain zeros, advance AHM and clear the zeros of the delete vectors before changing the partition **
There is no null value in the column, so a hint. I am promoting AHM right now. But how to clear zeros of removal vectors?
source
share