mysql - 如何从 MariaDB 迁移到 InfluxDB 日期时间到时间

Question

过去几天我正在尝试将一些数据从 MariaDB 导出为 InfluxDB 格式。

我使用以下语法从 MariaDB 导出数据:

    select CONCAT("insert cpu_load,host=" ,HostName ," value=", 
CPUUsedPercentage," ",UNIX_TIMESTAMP(CPUTime))
 from monitor.CPUStats;

输出是:

insert cpu_load,host=host1 value=2.85 1696683600

CPUtime 数据类型是日期时间，格式如下:

2/11/2017 3:56:18 PM


The output insert statement gets inserted in **InfluxDB** but the queries in **Grafana** or **Telegraf** are not retrieving nothing because of the time formats.

查询可能是:

    SELECT mean("value") AS "mean_value" FROM "monitor"."autogen"."cpu_load"
 WHERE time > now() - 1h AND "host"='prodvert03' GROUP BY time(10s) FILL(null)

错误消息是:

Your query is syntactically correct but returned no results

所以我确实相信是时间列格式。 UNIX_TIMESTAMP(CPUTime) 它不起作用。

任何想法或帮助将不胜感激。

谢谢

Answer 1

SELECT AVG(`value`) AS "mean_value"
    FROM `monitor`.`autogen`.`cpu_load`
    WHERE `time` > NOW() - INTERVAL 1 HOUR
      AND `host` = 'prodvert03'
    GROUP BY FLOOR(UNIX_TIMESTAMP(`time`) / 10);

会更接近。我不知道 FILL(null) 是什么意思。

许多无端的语法差异。