I’m having a problem with getting csv data into InfluxDB via the Telegraf files.csv plugin.
This is the config:
## CSV file test # https://docs.influxdata.com/telegraf/v1.9/data_formats/input/csv/ [[inputs.file]] files = ["/ubs/blue/autotest/var/tmp/clamp1.csv"] data_format = "csv" csv_header_row_count = 1 csv_delimiter = "," csv_tag_columns = ["REGION"] csv_measurement_column = "METRIC" csv_timestamp_column = "DATETIMESTAMP" # timestamp example "20190225T18:26:53.700430" csv_timestamp_format = "20060102T15:04:05.000000"
This is a few lines out of the the file:
DATETIMESTAMP,REGION,METRIC,LATENCYNS 20190304T16:03:55.266548,Clamp Simulator,latency,309474238 20190304T16:03:56.266697,Clamp Simulator,latency,162048311
And this is the result from select * from latency
1551717149000000000 20190304T16:32:28.978691 555844021 latency Clamp Simulator test_host 1551717150000000000 20190304T16:32:29.979692 880542363 latency Clamp Simulator test_host
It looks like its stored all the fields in the csv as one column so I’m unable to display and plot the value (latencyns).#
Any clues about what I have done wrong?