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?


  • 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.