I cannot purge deleted data manually and automatically

Hi Hamed. There's a lot of information on this topic, including some great training on it in our Vertica Essentials class. https://inter.viewcentral.com/events/cust/catalog.aspx?cid=arcsight&pid=1&lid=2&bu_id=6

In the mean time try reviewing: https://my.vertica.com/kb/Best-Practices-for-Deleting-Data/Content/BestPractices/Best-Practices-for-Deleting-Data.htm

and

https://my.vertica.com/docs/8.1.x/HTML/index.htm#Authoring/AdministratorsGuide/BulkDeletingPurging/ManuallyPurgingData.htm?Highlight=purge

Hi Hamed:

The command is SELECT MAKE_AHM_NOW();

Also, make sure all your nodes are up. The AHM will not advance if you have a node down. You can add the parameter true to make the AHM advance when a node is down but it is something of which you should be careful using. Check the docs if you need this.

Hi!
Thanks for your comments.
I solve this issue. I partitioned two tables 10 days ago, and did not reorganized tables. Now some data is partitioned and other data is not.
In partitioned tables, Vertica cannot purge deleted data from unpartitioned data that was not reorganized.
I reorganized my tables and then deleted data has been purged.
Command:
ALTER TABLE my_table REORGANIZE;

Thanks,
Hamed

[Solved]