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?

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
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.