If you need to check if your Vertica ROS is lagging behind your WOS, you can use the following query to retrieve the last good epoch (i.e : the last one written to disk, which ensures you won’t lose any data even in the case of a catastrophic failure where all your nodes would shut down simultaneously) :
SELECT epoch_number, epoch_close_time
JOIN epochs dbadmin ON epoch_number = last_good_epoch;
While loading data into the HPE Vertica database, you may run into this issue :
[Vertica][VJDBC](2245) ERROR: Attempted to create too many ROS containers for projection x.y
You may also notice that the error disapears if you wait a few minutes before restarting your data loading process. Only to reappear a little while later.
The issue comes from the vertica Read Optimized Store (ROS).
When loading data into Vertica, Continue reading