v1.4.2 docker version history indicator query cannot find indicator records for more than 1 day

[rbsrcy]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

检查该监控对应TDengine数据库表，发现近7天的数据是存在的，但是页面上查询不出来。

Expected Behavior

能查询1天以上的数据并显示出来

Steps To Reproduce

No response

Environment

HertzBeat version(s):v1.4.2

Debug logs

日志无报错

Anything else?

No response

[tomsun28]

因为tdengine的处理SQL在 1.4.2 版本更新了下，导致之前的数据查询不到

INSERT_TABLE_DATA_SQL = "INSERT INTO %s USING %s TAGS (%s) VALUES %s"

"SELECT ts, instance, `%s` FROM %s WHERE instance = '%s' AND ts >= now - %s order by ts desc"

变更为

INSERT_TABLE_DATA_SQL = "INSERT INTO `%s` USING `%s` TAGS (%s) VALUES %s";

"SELECT ts, instance, `%s` FROM `%s` WHERE instance = '%s' AND ts >= now - %s order by ts desc"

现在%s 修饰了表名，这样有可能之前建的表不识别, 建议手动修改老表

[jiashu1024]

我用的也是1.4.2的版本，刚从 iotdb 切换到 tdengine，我是最近一个小时数据都没有。