All Products
Search
Document Center

MaxCompute:Purge

Last Updated:May 25, 2023

Deletes the backup data from the current table or all tables in a project. The backup data that is deleted cannot be restored

Precautions

The backup data that is deleted from a table cannot be restored. Proceed with caution.

Syntax

  • Delete the backup data from a single table. Sample statement:

    purge table <table_name>;

    table_name: the name of the table from which you want to delete the backup data.

  • Delete the backup data from all tables in the current project. Sample statement:

    purge all;