ALTER STORAGE POLICY

Description

This statement is used to modify an existing cold and hot separation migration strategy. Only root or admin users can modify resources.

ALTER STORAGE POLICY  'policy_name'
PROPERTIES ("key"="value", ...);

Example

1. Modify the name to coolown_datetime Cold and hot separation data migration time point:

ALTER STORAGE POLICY has_test_policy_to_alter PROPERTIES("cooldown_datetime" = "2023-06-08 00:00:00");

2. Modify the name to coolown_countdown of hot and cold separation data migration of ttl

ALTER STORAGE POLICY has_test_policy_to_alter PROPERTIES ("cooldown_ttl" = "10000");
ALTER STORAGE POLICY has_test_policy_to_alter PROPERTIES ("cooldown_ttl" = "1h");
ALTER STORAGE POLICY has_test_policy_to_alter PROPERTIES ("cooldown_ttl" = "3d");

Keywords

ALTER, STORAGE, POLICY

Best Practice