使用datax将数据从InfluxDB抽取到TDengine过程记录

1. 编写InfluxDB数据查询语句

select  time as ts,device as tbname, ip,device as district_code from "L2_CS" limit 1000

2. 创建TDengine表

create database if not exists sensor;
create stable if not exists sensor.water(ts timestamp, ip varchar(50), device varchar(50)) 
tags(district_code nchar(12));

3, 编写datax配置json文件

{
  "job": {
    "content": [
      {
        "reader": {
          "name": "influxdbreader",
          "parameter": {
            "column": [
              "*"
            ],
            "connection": [
              {
                "endpoint": "http://127.0.0.7:8086",
                "database": "DisasterCloudDB"
              }
            ],
            "querySql": "select time as ts,device as tbname, ip,device as