repeated data returned in partition by TBNAME INTERVAL(12s) FILL(PREV)

[njzhangfei]

条件查询 ts>NOW-1m and ts<now partition by TBNAME INTERVAL(12s) FILL(PREV)

taos> SELECT LAST(ts),max(up_main_drive_noise),max(down_step_chain_work_noise),max(left_handrail_temperature),max(env_temperature), tbname from metro4gz.general_view_escalator where ts>NOW-1m and ts<now partition by TBNAME INTERVAL(12s) FILL(PREV) ;

    last(ts)         | max(up_main_drive_noise) | max(down_step_chain_work_noise) | max(left_handrail_temperature) | max(env_temperature) |             tbname             |

================================================================================================================================================================================ 2022-11-11 08:24:09.096 | 66.01300 | 66.60900 | 22.52200 | 44.84000 | gv_esc_1430033810805288962 | 2022-11-11 08:24:23.316 | 66.51100 | 66.45600 | 22.52200 | 44.48400 | gv_esc_1430033810805288962 | 2022-11-11 08:24:35.726 | 65.82200 | 65.80900 | 22.54400 | 44.68400 | gv_esc_1430033810805288962 | 2022-11-11 08:24:44.993 | 65.95000 | 66.20000 | 22.54400 | 44.55100 | gv_esc_1430033810805288962 | 2022-11-11 08:24:54.246 | 66.14700 | 66.14800 | 22.52200 | 44.55100 | gv_esc_1430033810805288962 | 2022-11-11 08:24:54.246 | 66.14700 | 66.14800 | 22.52200 | 44.55100 | gv_esc_1430033810805288962 | Query OK, 6 rows in database (0.054000s)

[yu285]

2022-11-11 08:24:54.246 | 66.14700 | 66.14800 | 22.52200 | 44.55100 | gv_esc_1430033810805288962 | 2022-11-11 08:24:54.246 | 66.14700 | 66.14800 | 22.52200 | 44.55100 | gv_esc_1430033810805288962 | 如果你说的重复数据是指的这两行，有可能是正常的。

记录时间戳的列是_wstart

你可以把它加上：

SELECT _wstart, LAST(ts),max(up_main_drive_noise),max(down_step_chain_work_noise),max(left_handrail_temperature),max(env_temperature), tbname from metro4gz.general_view_escalator where ts>NOW-1m and ts<now partition by TBNAME INTERVAL(12s) FILL(PREV) ;