为了更快的定位您的问题，请提供以下信息，谢谢
【详述】information_schema.tables_config中PROPERTIES的值的比较随机 如何有通用的解析方法
– starRocks 3.2.4
CREATE TABLE web_site_access_dynamic (
event_day date NULL COMMENT “”,
site_id int(11) NULL DEFAULT “10” COMMENT “”,
city_code varchar(100) NULL COMMENT “”,
user_name varchar(32) NULL DEFAULT “” COMMENT “”,
pv bigint(20) NULL DEFAULT “0” COMMENT “”
) ENGINE=OLAP
DUPLICATE KEY(event_day, site_id, city_code, user_name)
PARTITION BY RANGE(event_day)
(PARTITION p20240519 VALUES [(“2024-05-19”), (“2024-05-20”)),
PARTITION p20240520 VALUES [(“2024-05-20”), (“2024-05-21”)),
PARTITION p20240521 VALUES [(“2024-05-21”), (“2024-05-22”)),
PARTITION p20240522 VALUES [(“2024-05-22”), (“2024-05-23”)),
PARTITION p20240523 VALUES [(“2024-05-23”), (“2024-05-24”)),
PARTITION p20240524 VALUES [(“2024-05-24”), (“2024-05-25”)),
PARTITION p20240525 VALUES [(“2024-05-25”), (“2024-05-26”)))
DISTRIBUTED BY HASH(event_day, site_id)
PROPERTIES (
“replication_num” = “3”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“dynamic_partition.start” = “-3”,
“dynamic_partition.end” = “3”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.buckets” = “32”,
“dynamic_partition.history_partition_num” = “0”,
“in_memory” = “false”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“compression” = “LZ4”
);
– 解析 properties的脚本不通用，properties中的信息可以自定义写入，解析出来的和实际不符：
select t.TABLE_NAME
,JSON_QUERY(t.PROPERTIES,’$.enable_persistent_index’) enable_persistent_index
,JSON_QUERY(t.PROPERTIES,’$.replication_num’) replication_num
,JSON_QUERY(t.PROPERTIES,’$.compression’) compression
,JSON_QUERY(t.PROPERTIES,’$.in_memory’) in_memory
,split_part(element_at(split(JSON_QUERY(t.PROPERTIES,’$.dynamic_partition’),","),1),’:’,-1) dynamic_partition_enable
,split_part(element_at(split(JSON_QUERY(t.PROPERTIES,’$.dynamic_partition’),","),2),’:’,-1) dynamic_partition_time_unit
,split_part(element_at(split(JSON_QUERY(t.PROPERTIES,’$.dynamic_partition’),","),3),’:’,-1) dynamic_partition_time_zone
,split_part(element_at(split(JSON_QUERY(t.PROPERTIES,’$.dynamic_partition’),","),4),’:’,-1) dynamic_partition_start
,split_part(element_at(split(JSON_QUERY(t.PROPERTIES,’$.dynamic_partition’),","),5),’:’,-1) dynamic_partition_end
,split_part(element_at(split(JSON_QUERY(t.PROPERTIES,’$.dynamic_partition’),","),5),’:’,-1) dynamic_partition_prefix
,split_part(element_at(split(JSON_QUERY(t.PROPERTIES,’$.dynamic_partition’),","),6),’:’,-1) dynamic_partition_buckets
from information_schema.tables_config t
where t.table_name=‘web_site_access_dynamic’
