doris2.1.10版本 3fe9be
配置48C 376G
ccc_user_ops表一共有400G
查询这个sql,返回数据很快,数据返回以后,整个be节点全部hang住,所有的查询都阻塞.....
求助排查方向
select
*
from(
select
*,
ROW_NUMBER() OVER(
PARTITION BY refId
ORDER BY
cTime DESC
) AS num
from(
SELECT
JSON_EXTRACT_STRING(input, '$.req.memId') memId,
JSON_EXTRACT_STRING(input, '$.req.devId') AS devId,
cTime,
refId
FROM
ccc_user_ops
) a
) b
WHERE
b.num = 1