...
Code Block |
---|
CREATE RESOURCE "storage_policy_name" PROPERTIES( "type"="storage_policy", "cooldown_datetime" = "2022-06-01", // time when data is transfter to medium "cooldown_ttl" = 1h, // data is transfter to medium after 1 hour "s3_*" ); CREATE TABLE example_db.table_hash ( k1 BIGINT, k2 LARGEINT, v1 VARCHAR(2048) REPLACE, v2 SMALLINT SUM DEFAULT "10" ) UNIQUE KEY(k1, k2) DISTRIBUTED BY HASH (k1, k2) BUCKETS 32 PROPERTIES( "storage_medium" = "SSD", "sotrage_policy" = "storage_policy_name" ); |
Users can modify either cooldown_datetime or cooldown_ttl of a storage policy, others attributed are not allowed to be modified. For simplicity, be refresh storage policy periodically to refresh ak sk.
Decision
Action
Result
Scheduling
...