Doris2.1.5版本
查询冷热分层数据(冷数据存储在oss中)表报错,经查看tablet=45391858是冷数据,这问题应该如何处理?
报错如下:
SQL Error [1105] [HY000]: errCode = 2, detailMessage = (ali-doris-prod-01)[CANCELLED]failed to initialize storage reader. tablet=45391858, res=[INTERNAL_ERROR]failed to read: curlCode: 28, Timeout was reached code=-1 type=99, request_id=, backend=ali-doris-prod-01
执行SQL如下:
SELECT
hpsid,
freq,
COUNT(1) as uv
FROM
(
SELECT
hpsid,
mac,
SUM(freq) as freq
FROM
(
SELECT
hpsid,
cityCode,
mac,
SUM(freq) AS freq
FROM
(
SELECT
dt,
hpsid,
SUBSTRING(cityCode, 5, 4) as cityCode,
mac,
COUNT(1) as freq
FROM
ad_monitor.huan_ad_monitor_impression_log hamil
WHERE
dt between '2024-07-30' AND '2024-09-13'
AND SUBSTRING(cityCode, 5, 4) IN ('3203')
AND platform IN ('huanunion_adx')
AND hpsid IN ('114170')
GROUP BY
dt,
SUBSTRING(cityCode, 5, 4),
mac,
hpsid ) t1
GROUP BY
cityCode,
mac,
hpsid ) t2
GROUP BY
mac,
hpsid ) t3
GROUP BY
freq,
hpsid
ORDER BY
freq
;