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
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.