【TDengine 使用环境】
生产环境
【TDengine 版本】3.3.3.0
【操作系统以及版本】
【部署方式】非容器部署
【遇到的问题：问题现象及影响】我在执行 如下代码时报错，select ‘北美prod：61001.2’ as env, device_id, ts, idf_1024, idf_1054, idf_1011, idf_1011_v1, local_ts, SUBSTRING(local_ts,1,10) AS local_dt
from (SELECT device_id, ts, idf_1024, idf_1054, idf_1011
,case when device_id = ‘XZT056460017524’ then TO_ISO8601(CAST(idf_1024 AS bigint), “-06:00”)
when device_id = ‘XZT056450152898’ then TO_ISO8601(CAST(idf_1024 AS bigint), “-06:00”)
when device_id = ‘NZT05180100001X’ then TO_ISO8601(CAST(idf_1024 AS bigint), “+08:00”)
when device_id = ‘XZT056460017535’ then TO_ISO8601(CAST(idf_1024 AS bigint), “-04:00”)
when device_id = ‘XZT056460017534’ then TO_ISO8601(CAST(idf_1024 AS bigint), “-06:00”)
when device_id = ‘XZT056460017496’ then TO_ISO8601(CAST(idf_1024 AS bigint), “-04:00”)
else null end as local_ts
,case when idf_1011 > 0 then idf_1011 else null end as idf_1011_v1
FROM device_shadow.product_1872162996169281538
WHERE ts>=‘2026-05-13T00:00:00+08:00’ and ts<=‘2026-05-14T00:00:00+08:00’ and (idf_1054 is not null or idf_1011 is not null)
AND device_id IN (‘XZT056450152898’,‘XZT056460017496’,‘XZT056460017534’,‘XZT056460017524’,‘XZT056460017535’,‘NZT05180100001X’,‘XZT056450152891’)
) a
PARTITION BY device_id
INTERVAL(1m) FILL(PREV); 报错的信息如下，`Start(end) time of query range required or time range too large`，我该怎么改