Search before asking
- I had searched in the issues and found no similar issues.
Description
show create table support StorageMedium/CooldownTime
Use case
We are currently migrating some tables from HDD to SSD. Currently, we can only check whether the table uses SSD through /dbs, which is not intuitive
Related issues
- No response*
Are you willing to submit PR?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct
3条答案
按热度按时间c9x0cxw01#
Doris do not support setting these property for each partition in
create table stmt.So what will you do to support this?
sg3maiej2#
when use show create test
CREATE TABLEtest(courseIdint(11) NOT NULL COMMENT "",lessonIdint(11) NOT NULL COMMENT "",typeint(11) REPLACE_IF_NOT_NULL NULL COMMENT "" ) ENGINE=OLAP AGGREGATE KEY(courseId,lessonId) COMMENT "测试" DISTRIBUTED BY HASH(courseId) BUCKETS 150 PROPERTIES ( "replication_num" = "3", "in_memory" = "false", "storage_format" = "V2", "storage_medium" = "SSD", "cooldownTime" = "9999-12-31 23:59:59" );add storage_medium and cooldownTime
trnvg8h33#
Currently, there is a problem. If there is no show create table, it may cause HDD to be built in the next table reconstruction