doris的2.0.4,mysql的catalog的随机查询太慢,在mysql很快

Viewed 45

select
*
from
mysql_catalog.mysqldb.mysqltable
where
id >= ((
select
max(id)
from
mysql_catalog.mysqldb.mysqltable)-(
select
min(id)
from
mysql_catalog.mysqldb.mysqltable))* rand() + (
select
min(id)
from
mysql_catalog.mysqldb.mysqltable)
limit 0,5000

1 Answers
  1. 可以基于query profile分析看看
  2. 可以升级至2.0最新的稳定版本2.0.13对比看看,排除些版本缺陷问题