CLEAR_PROJECTION_REFRESHES

Triggers Vertica to clear information about refresh operations for projections immediately.

Syntax

CLEAR_PROJECTION_REFRESHES()

Notes

Information about a refresh operation—whether successful or unsuccessful—is maintained in system table PROJECTION_REFRESHES until the function CLEAR_PROJECTION_REFRESHES executes or the storage quota for the table is exceeded. The table's IS_EXECUTING column returns a boolean value that indicates whether the refresh is running now (t) or occurred earlier (f).

Privileges

Superuser

Example

To immediately purge projection refresh history, use the CLEAR_PROJECTION_REFRESHES() function:

=> SELECT CLEAR_PROJECTION_REFRESHES();
 CLEAR_PROJECTION_REFRESHES
----------------------------
 CLEAR
(1 row)

Only the rows where the PROJECTION_REFRESHES.IS_EXECUTING column equals false are cleared.