Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
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