【详述】创建表时,PROPERTIES中只指定了enable_storage_cache为false,表创建出来后,show create table 看到storage_cache_ttl参数也有值了
【业务影响】测试阶段
【StarRocks版本】3.0.4
【集群规模】1fe 1be 测试阶段
【机器信息】16C 64G
【建表时的PROPERTIES】
PROPERTIES (
“replication_num” = “1”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “UTC”,
“dynamic_partition.start” = “-40”,
“dynamic_partition.end” = “4”,
“dynamic_partition.prefix” = “p”,
“in_memory” = “false”,
“storage_format” = “V2”,
“enable_storage_cache” = “false”
);
【建立表后 show create table 看到的PROPERTIES】
PROPERTIES (
“replication_num” = “1”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “UTC”,
“dynamic_partition.start” = “-40”,
“dynamic_partition.end” = “4”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.history_partition_num” = “0”,
“enable_storage_cache” = “false”,
“storage_cache_ttl” = “2592000”,
“enable_async_write_back” = “false”,
“compression” = “LZ4”
);
