Truncate partition is possible?

(yeriahn) #1

I wonder about managing table partitons.
If the table “test” partitioned, Could I add partiton more?
like "alter table test add partition less than … "

And…
I wonder could I truncate single partiton.

I want to manage the partiton for current data, old data seperatly.
I have to delete old data. so I want truncate single partition stored old data speedy.

(Ron Arévalo) #2

Hey @yeri,

Regarding adding more partitions to a table, this is doable, you can check out the docs on how to set that up here.

As for truncating a specific partition—at the moment that is not possible, however we do have an open issue that you can follow here which would allow for row-level ttl so you would be able to delete old data.

Thanks,

Ron