Attempted to create too many ROS containers for projection VDWTCUDB.pwr_st_evt_b1
HINT: Likely due to partitioning.
Hope you are doing well we are getting the below error whenever we load data one after the other , and the table is partition on the basis of month and has close to 20 years of data . We had several discussion with Vertica DBA and they want us to remove the old data which is not required , we can do that but I had a doubt is there any way where we can support huge data of several years
Note : When we do MO or Purging then our jobs succeed but after few days we again face the issue once the load on that table is done in a bulk.