Doris2.1.5查询冷数据(冷数据在oss上)报错,应该如何处理

Viewed 58

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
;
2 Answers

这块应该是tablet 45391858 的状态问题,具体还需要根据日志详细判断。
目前暂无此情况,后续有问题可以新起一个帖子继续跟进

我们设置15天前的数据都存储到oss上
image.png

image.png