doris2.1.8版本,简单查询偶发固定返回 800001 行数据,正常应为 100 万 + 行

Viewed 15

通过 ProxySQL 代理访问,执行无 JOIN、无聚合、无排序、无 LIMIT 的简单单表过滤 SQL,
偶发静默返回固定 800001 行数据,正常数据量为 100 万 + 行,无任何报错。
审计日志如下图确实返回800001行数据

sql“

select open_id as open_id 
from hive_ads.ads_market_reg_cust_label_df 
where  open_id is not null 
and open_id <> '' 
and last_credit_apply_status not like '%ACE%' 
and last_credit_apply_status not like '%APS%' 
and open_id is not null 
and open_id <> ''

image.png
第二个demo,返回应该是4条记录,但是实际只返回1条

SELECT '1' as aa
union all
SELECT '2' as aa
union all
SELECT '3' as aa
union all
SELECT '4' as aa

image.png

0 Answers