【详述】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)