The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
not able to delete data
Hi All, Trying a simple time-based (< timestamp) delete on a particular table in our database. The total number of records deleted is 1887497. In order to ensure that the delete goes through I am performing manual purging. So the sequence is something like :: a) delete b) select make_ahm_now(); c) select purge_table('table_name'); However the purge command returns instantly and on checking further, the records reappear in the table. This is quite puzzling to me. Any help would be appreciated. The delete_vectors table doesn't contain any records corresponding to the delete performed. Thanks Ravi.