change active partition (v8.1.1)

Moderator: NorbertKrupa

Post Reply
Posts: 1
Joined: Wed Sep 27, 2017 5:10 pm

change active partition (v8.1.1)

Post by theDataGuy » Wed Sep 27, 2017 5:29 pm

I have a large table partitioned by year which I am constantly trickle-loading data into for the current year, 2017, and therefore always need the current year to be the active partition. But if I attempt to backload data for a year that doesn't currently exist in the partition (2014, for example), then the active partition changes to the "newest" year of data loaded, 2014. This eventually causes problems like lengthy mergeouts, high ROS container count, etc.

My question is, does anyone know a way to force a change in active partition key on a partitioned table? In this case, I want to change it back to current year. Or maybe have a better solution that I haven't thought of?


User avatar
Site Admin
Site Admin
Posts: 1806
Joined: Sat Jan 21, 2012 4:58 am

Re: change active partition (v8.1.1)

Post by JimKnicely » Mon Oct 02, 2017 6:29 pm


This is a current feature request that is coming soon! I'll update this thread when I find out which of the upcoming releases will have it!

Jim Knicely


Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “General”