I am trying to have multiple measurements in the influxdb database. The tag keys for all measurements are common, only field keys differ. The tag keys are showing properly, but the field keys are getting mixed up. The files are in CSV format and there are too many columns, so I am facing difficulty …

@Pratik_Das_Baghel - It’s hard to give specific advice without a sample of your csv, your telegraf configuration, and an example of what you mean by “mixed up” field keys. I would double check your telegraf config to ensure the CSV parsing is happening as you like. Test it with a smaller version of …

@philjb sure. [[outputs.influxdb]] urls = [“ http://influxdb:8086 ”] database = “omfinal2” ########### [[processors.converter]] [processors.converter.tags] measurement = [“type”] ########## [[inputs.kinesis_consumer]] #all other fields defined data_format = csv csv_header_count = 1 csv_…

I think I’m beginning to understand the problem you are describing. I don’t quite yet understand what you mean with that my first file contains some columns which are not present in others… but in field keys they are showing in that measurements also, where they should not be present. but will thin…

@philjb . The problem is solved now thank you.

What is your solution? Glad you solved it.

Used 4 different kinesis streams and modified config file accordingly.

Multiple measurements

Welcome & Getting Started

Pratik_Das_Baghel November 6, 2020, 11:08am 8

@philjb i have another doubt regarding continuous query format. Can you help me with that? Err - expected field arguments in mean()

Topic		Replies	Views
Field values from another measurement mixed in another measurement influxdb	17	609	June 17, 2022
Handling multiple files Welcome & Getting Started	2	715	October 17, 2020
Using telegraf plugin for aws kinesis stream Welcome & Getting Started	2	782	October 13, 2020
Tags or Fields when there are many duplicated "tags" and "fields: influxdb	0	631	March 29, 2019
Telegraf send only last line of CSV to influxDB Telegraf	3	773	October 4, 2022

Multiple measurements

Related topics