How restore deleted data?

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