...
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"
); |
Decision
Action
Result
Scheduling
...