SET_DATA_COLLECTOR_POLICY
Sets a size restraint (memory and disk space in kilobytes) or time restraint for the specified Data Collector table on all nodes. If nodes are down, the failed nodes receive the setting when they rejoin the cluster.
Before you change a retention policy, you can view its current setting by calling meta-function GET_DATA_COLLECTOR_POLICY.
Syntax
SET_DATA_COLLECTOR_POLICY('component', 'memoryKB', 'diskKB' [,'interval'] )
Parameters
component | Configures the retention policy for the specified component. |
memoryKB | Specifies in kilobytes the memory size to retain. |
diskKB | Specifies in kilobytes the disk size. |
interval |
INTERVAL data type that optionally specifies how long to retain the specified component on disk. To disable a time restraint, set interval to a negative integer. You can use SET_DATA_COLLECTOR_TIME_POLICY to specify a time restraint only, or to turn off a time restraint that was set earlier with this function. Default: -1 |
If you specify interval, Vertica enforces the setting that is exceeded first—size or time. Before you include a time restraint, verify that the disk size capacity is sufficiently large.
Privileges
Superuser
Examples
See Configuring Data Retention Policies.