Options
How restore deleted data?
We are testing product Vertica Community Edition (7.2.2-1). During the tests we found next problem. We deleted some data (as i understand just marked this data as "deleted").
We see this data in storage_containers but how it could be restored?
Is it posible?
Have Vertica something for that?
0
Comments
You cannot restore from the vectors data ! No undo available yet , and if there will be one Vertica will no longer be as fast as it is now
.
What you can do is look at the table in a point in time where the data was not deleted
Example :
using time value
AT TIME 'timestamp' select * from table;
using the epoch value
AT EPOCH select * from table;
Then you create a data set from the result set and put it back in the original table .
But this will work only if you have your retention parameter set if is off then the delete vectors will be purged at the next TM job/run.
Hope this helped