【详述】sql中只有一个count distinct计算，结果秒出，有多个count distinct计算时，查询不结束
【StarRocks版本】3.3.11
【集群规模】例如：3fe + 30 be
【机器信息】30*16c64g
示例sql：
select
dt as dt1,
count(1) as num,
count(distinct g_sn) as g_sn,
count(distinct s_id) as s_id,
sum(s_cnt) as s_cnt,
sum(s_flag) as s_flag,
sum(flag) as flag,
sum(jy_flag) as jy_flag
from
hive.dw.dw_test
where
dt = ‘20250521’
group by
dt
limit
100000
query_error.profile (70.2 KB)
