...
StoragePolicy
The proposal propose proposes the storage policy. Users can create a storage policy and apply it to a table.
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" ); |
...