【详述】查询结果时有时无
【背景】
如下SQL执行后结果返回时有时无，3个distinct的时候有问题，2个及一下没问题。
SELECT dt, col1, col2, COUNT(DISTINCT (CASE
WHEN b = ‘bb’ and get_json_string(properties, ‘$.cc’) = ‘yy’ THEN gaid
ELSE NULL END)) y_uv,
COUNT(DISTINCT (CASE WHEN b = ‘bb’ and get_json_string(properties, ‘$.cc’) = ‘xx’ THEN gaid
ELSE NULL END)) x_uv,
COUNT(DISTINCT (CASE WHEN b = ‘bb’ and get_json_string(properties, ‘$.cc’) = ‘zz’ THEN gaid
ELSE NULL END)) z_uv
from test
where dt >= ‘2022-11-23 00’
and dt <= ‘2022-11-23 23’
GROUP BY dt, col1, col2 ;
表基本信息,dt为datetime类型
ENGINE=OLAP
DUPLICATE KEY(dt, aid)
COMMENT “OLAP”
PARTITION BY RANGE(dt)
DISTRIBUTED BY HASH(aid, gaid)
【业务影响】
【StarRocks版本】2.4.0
【集群规模】例如：1fe+2be
【机器信息】大内存
【附件】