【TDengine 使用环境】
测试
【TDengine 版本】3.4.0.2
【操作系统以及版本】
【部署方式】docker容器
【集群节点数】单机
语法报错：
select
device_name,
LAST_ROW(ts) as ts,
year,
month,
day,
hour,
minute,
second,
temperature,
temperature_daily_maximum,
temperature_daily_minimum,
humidity,
wind_speed,
wind_speed_average_2_mimiute,
wind_speed_average_10_minute,
wind_direction,
atmospheric_pressure,
horizontal_total_irradiance,
horizontal_total_exposure,
horizontal_total_exposure_month,
horizontal_total_exposure_year,
peak_sunshine_hours,
sunshine_hours,
cleanness_1,
cleanness_2,
gps_status,
battery_soc,
battery_voltage,
battery_alarm,
is_online
from
iot_gems.env_ts
where
(ts between ‘2026-04-02 12:29:47’ and ‘2026-04-03 12:29:47’)
group by device_name,INTERVAL(5m)
order by
ts, device_name
错误信息：SQL 错误 [9728]: TDengine ERROR (0x2600): syntax error near “interval(5m)
order by
ts, device_name”