Tags priority with telegraf

InfluxDB 3
1

Hi, I send appication logs in InfluxDB3 (OSS v3.7) using Telegraf

In docs we have this recommendation
On first write, sort tags by query priority
but Telegraf change tag order
from log,env=qa,tier=frontend,source=web,level=error …
to log,level=error,env=qa,source=web,tier=frontend …

What is a proper way to handle this?
(or only sending 1st table log with proper order through http/cli manually)

Telegraf v1.37
telegraf config

[agent]
      interval = "10s"
      metric_batch_size = 2000
      metric_buffer_limit = 50000
      flush_interval = "5s"
      flush_jitter = "1s"
      precision = ""
      debug = false
      quiet = false
      logfile = ""
      omit_hostname = true

    [[inputs.influxdb_v2_listener]]
      read_timeout = "10s"
      write_timeout = "10s"
      max_body_size = "100MiB"
      parser_type = "internal"
      data_format = "influx"
2

Yeah, the recommendation here is to manually send one log with the proper ordering before starting Telegraf up. With line protocol, you can sort your tags in the exact order of query priority. Future writes from Telegraf will then follow that ordering. If you don’t manually write the first log, the ordering of tags will instead be determined by the implementation of the Telegraf plugins you’re using.

3

I hard-delete table, manually write the first log, start log sending through telegraf.

Some ideas on how to check is this priority properly stored on influxdb side?
(in information_schema.columns, influxdb data explorer I see only lexicographic order of tags & fields)

4

Late response because I missed the reply with the follow-up question, but better late than never…

You can determine order in storage by querying information_schema.columns, e.g.

SELECT column_name, ordinal_position FROM information_schema.columns WHERE table_name = ‘<table>’ ORDER BY ordinal_position ASC;