Questions tagged [influxdb-2]

More information here https://v2.docs.influxdata.com/v2.0/. Version 2 uses a new query language called Flux and it is also reactive in nature.

289 questions
0
votes
1 answer

telegraf: AWS IoT-Core to InfluxDB: i/o timeout

I have an existing (working) setup that uses InfluxDB's Native Subscriptions to transfer data from the AWS IoT-Core (as the MQTT broker) to our InfluxDB-Cloud instance. Native Subscriptions are being removed as a feature in InfluxDB - and while I…
0
votes
1 answer

Write to InfluxDB in realtime

I'm using the self-hosted version of InfluxDB 2.7 to write sensor readings into the database. If would like to visualize the sensor readings in real time (via InfluxDB UI or my own web app). Unfortunately the data does not show up in real-time. The…
Fred
  • 1,103
  • 2
  • 14
  • 35
0
votes
1 answer

Finding count of data grouped by tag value with InfluxDB and Flux

I am migrating our applications from InfluxQL and Influx 1.8 to Flux and am struggling with grouping data by tag value. We were previously writing directly to InfluxDB and are now writing to InfluxDB via OpenTelemetry and Telegraf. An example of an…
nullPainter
  • 2,676
  • 3
  • 22
  • 42
0
votes
0 answers

influx DB: tokenize python list

I have this query: from(bucket: "my_bucket") |> range(start: -24h) |> filter(fn: (r) => r["_measurement"] == "my_mea") |> filter(fn: (r) => r.oper == "start") |> filter(fn: (r) => r["_field"] =~ /devices::.+::port_redir$/) |> keep(columns:…
ManiAm
  • 1,759
  • 5
  • 24
  • 43
0
votes
0 answers

How to uninstall influxdB in windows

I initially thought that i would require influxdB but stands out I actually don't need it and now I want to uninstall it. Please suggest how to do it cleanly. The other post I saw is for centos. How to uninstall influxdb with all its data and…
Shariq Azim
  • 136
  • 16
0
votes
0 answers

influxdb localhost points the API swagger.json to a path that I cannot serve

I installed InfluxDB behind a proxy (Apache) and gave it the following rule: ProxyPassMatch "^influxdb/(.*)" "http://localhost:8086/$1" When I browse the url: mycompany.com/influxdb/docs it loads with the following error: Something went…
Ricky Levi
  • 7,298
  • 1
  • 57
  • 65
0
votes
0 answers

How to extract first record _time value in a flux query?

I am attempting to extract the first time value of a query in order to use it with the function experimental.alignTime. I have tried various options, but none have worked. Here is an example of the last solution I tried: import…
0
votes
0 answers

InfluxDB - Specific data missing from bucket every single time

I've been following a very basic tutorial for reading data from a sensor and writing it to a bucket in influxdb. The tutorial is out of date, so I've updated my code to use the new apis and query protocols. However, I'm noticing that everytime I…
0
votes
0 answers

Telegraf loading snmp plugin, but not appearing on influxdb2

maybe someone here can point me to the correct direction. I have setup telegraf and influxdb2. My goal is to enable snmp plugin and graph it with grafana. I enabled snmp plugin on telegraf.conf and nodes configs on telegraf.d folder. The configs…
B81
  • 1
0
votes
1 answer

How to disable some Influx queries in Grafana based on variable value?

I have a Dashboard graph in Grafana, where I need to select data from Influx. However, I want to use variable to change which queries are active and which are not. Currently Grafana does not support variables in transformations, thus I am trying to…
rojikada
  • 347
  • 1
  • 3
  • 9
0
votes
0 answers

InfluxDB - Get sum of distinct values per day

I have entries coming in every day and sometimes twice a day with same value. The same value can come in next day or next week too. I need to sum these values so they are distinct only for that day and still count towards the sum even if it same…
0
votes
0 answers

How can I use time series database and visualization frameworks to render growing data with ancient timestamps?

I am gathering time series data from the game "Patrician 3" (inventory of each town and trading office), which takes place in the middle ages (1300+). Since transforming time series data into graphs is a solved problem, I'd like to use an…
Benni
  • 1,030
  • 2
  • 11
  • 18
0
votes
0 answers

influxdb-client for python is not taking custom timestamps

I am new to InfluxDB and have been trying to store a datapoint with multiple fields having custom timestamp from a dictionary into the influxdb via the influxdb-client == 1.36.1 I followed the pypi documentation and tried to give custom timestamp…
0
votes
0 answers

Is there a way to convert this InfluxQL to Flux for data imported via telegraf?

I am using InfluxDB V2 (cloud) and have the following script to gather data from the source (kafka_consumer as an input to telegraf): SELECT * FROM "kafka_consumer" WHERE time >= now() - interval '7 days' I was wondering how to convert this to Flux…
ssiew
  • 1
  • 1
0
votes
0 answers

Influxdb2 data migration/transformation

I have a bucket which stores data received via telegraf as timeseries. The original datasource is mqtt so the fields in the single data frames in the bucket are basically the topic layout of the mqtt subscription. Now the mqtt publisher will change…
Kraego
  • 2,978
  • 2
  • 22
  • 34