PURGE_TABLE
This function was formerly named PURGE_TABLE_PROJECTIONS().
Note
This function was formerly named PURGE_TABLE_PROJECTIONS(). Vertica still supports the former function name.Permanently removes deleted data from physical storage so disk space can be reused. You can purge historical data up to and including the Ancient History Mark epoch.
Purges all projections of the specified table. You cannot use this function to purge temporary tables.
This is a meta-function. You must call meta-functions in a top-level SELECT statement.
Behavior type
VolatileSyntax
PURGE_TABLE ( '[[database.]schema.]table' )
Parameters
[database.]schemaDatabase and schema. The default schema is
public. If you specify a database, it must be the current database.table- The table to purge.
Privileges
-
Table owner
-
USAGE privilege on schema
Caution
PURGE_TABLE could temporarily take up significant disk space while the data is being purged.Examples
The following example purges all projections for the store sales fact table located in the Vmart schema:
=> SELECT PURGE_TABLE('store.store_sales_fact');