【详述】问题详细描述
【背景】做过哪些操作？
【业务影响】
【StarRocks版本】例如：2.5.4
【集群规模】例如：3fe（1 follower+2observer）+8be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：40C/128G/万兆
【联系方式】为了在解决问题过程中能及时联系到您获取一些日志信息，请补充下您的联系方式，例如：社区群4-小李或者邮箱，谢谢
【附件】
select count(*) from dmm_mod_reason_d where dt =‘2023-06-18’ ;
select dt,count(distinct accountid) from dmm_mod_reason_d where dt =‘2023-06-18’ group by dt order by dt;
select dt,count(*),count( partner),count(distinct accountid) from dmm_mod_reason_d where dt =‘2023-06-18’ group by dt order by dt;
select dt,count(*),count(distinct accountid, dt) from dmm_mod_reason_d where dt =‘2023-06-18’ group by dt order by dt;
建表语句：
create table dmm.dmm_mod_reason_d (
accountid varchar(200) DEFAULT ‘’ COMMENT ‘id’,
partner varchar(300) DEFAULT ‘’ COMMENT ‘渠道’,
dt date COMMENT ‘日期’
) PARTITION BY RANGE(dt) (START (“2023-01-01”)END (“2023-04-27”) EVERY (INTERVAL 1 day)
) DISTRIBUTED BY HASH(accountid) BUCKETS 10 PROPERTIES(
“replication_num” = “2”,
“dynamic_partition.enable” = “true”,
“dynamic_partition.time_unit” = “DAY”,
“dynamic_partition.time_zone” = “Asia/Shanghai”,
“dynamic_partition.start” = “-1080”,
“dynamic_partition.end” = “1”,
“dynamic_partition.prefix” = “p”,
“dynamic_partition.buckets” = “2”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”
);