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?
Thanks.
change active partition (v8.1.1)
Moderator: NorbertKrupa
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: change active partition (v8.1.1)
Hii,
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!
Thanks!
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!
Thanks!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: change active partition (v8.1.1)
Hi Jim, was this feature implemented yet? I'm considering starting using the new version and if this feature is in, I'm sold.JimKnicely wrote: ↑Mon Oct 02, 2017 6:29 pmHii,
This Money Mutual review 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!
Thanks!
Last edited by BobRis on Tue Nov 22, 2022 3:24 pm, edited 2 times in total.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: change active partition (v8.1.1)
Hi,
You can now set the Active Partition Count at the table level.
See:
https://www.vertica.com/docs/9.1.x/HTML ... itions.htm
From the doc:
You can now set the Active Partition Count at the table level.
See:
https://www.vertica.com/docs/9.1.x/HTML ... itions.htm
From the doc:
Note: For tables partitioned by non-temporal attributes, set its active partition count to reflect the number of partitions that are subject to a high level of activity—for example, frequent loads or queries.
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: change active partition (v8.1.1)
Thanks for sharing!JimKnicely wrote: ↑Thu Sep 27, 2018 4:46 pmHi,
You can now set the Active Partition Count at the table level.
See:
https://www.vertica.com/docs/9.1.x/HTML ... itions.htm
From the doc:
Note: For tables partitioned by non-temporal attributes, set its active partition count to reflect the number of partitions that are subject to a high level of activity—for example, frequent loads or queries.
All the best: https://diceus.com/comparison-of-12-bes ... e-systems/