【详述】
sr版本：2.5.2
执行的sql为：
select substr(stat_date,1,7),count(distinct stat_date) as days,count(*) as cnt from rpt.rpt_trip_wallet_operate_daily group by substr(stat_date,1,7) order by substr(stat_date,1,7);执行这个sql，发现days和cnt的结果是一摸一样的。
rpt.rpt_trip_wallet_operate_daily的表结构为：
CREATE TABLE rpt_trip_wallet_operate_daily (
stat_date date NULL COMMENT “”,
etl_time varchar(100) NULL COMMENT “”,
reg_city_code varchar(100) NULL COMMENT “注册城市”,
reg_city_name varchar(100) NULL COMMENT “注册城市名称”
) ENGINE=OLAP
DUPLICATE KEY(stat_date)
COMMENT “”
PARTITION BY RANGE(stat_date)
(PARTITION p20220323 VALUES [(“2022-03-23”), (“2022-03-24”)),
PARTITION p20220324 VALUES [(“2022-03-24”), (“2022-03-25”)),
PARTITION p20230407 VALUES [(“2023-04-07”), (“2023-04-08”)))
DISTRIBUTED BY HASH(stat_date) BUCKETS 10
PROPERTIES (
“replication_num” = “3”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“dynamic_partition.start” = “-2147483648”,
“dynamic_partition.end” = “1”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.buckets” = “10”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”,
“compression” = “LZ4”
); |