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
1
vote
0 answers

query array of measurement from influxdb 2

obviously I don't understand the new Flux language approach in influxdb2. What I have: A running influxdb1 instance where I write a json with different values for a measurement. Now I have upgraded this influxdb to version 2. I can see in the UI the…
solick
  • 2,325
  • 3
  • 17
  • 29
1
vote
0 answers

Export flux (Influxdb 2.0) database into csv in CLI

I found that we can send a CSV file into Influxdb 2.0, but is the reverse operation possible? How can I export flux database into CSV file in CLI?
1
vote
0 answers

I accidentally deleted the admin's token

I'm using Influx 2.0 (https://docs.influxdata.com/influxdb/v2.0/) and after creating the admin user with influx setup, I accidentally deleted the admin's token and don't know how to restore it. No created token has all privileges, so it's not as…
chococroqueta
  • 694
  • 1
  • 6
  • 18
1
vote
1 answer

InfluxDBv2 - get a remote config working as a telegraf windows service

I'm trying to use the remote config feature of InfluxDB and Telegraf. If I set the enviroment variable with $env:INFLUX_TOKEN = "thisIsMyToken" and then test things with .\telegraf.exe --config "https://influxdbserver:port/myremoteconfig"…
doofesohr
  • 177
  • 1
  • 11
1
vote
1 answer

influxdb 2.0 certificate verify failed: certificate has expired (_ssl.c:1129)

When I'm trying to delete or insert data into influxDB 2.0 I suddenly started getting this error. It was working without any issue earlier Does anyone know how to fix it [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has…
1
vote
1 answer

Problem with inserting pandas dataframe into influxdb

I am trying to write data into influxdb and querying it to return the data but all I am getting is empty dataframe. I have used official influxdb documentation by creating a dataframe and writing and that works fine. But when I import a csv/pickle…
T2020
  • 61
  • 6
1
vote
1 answer

InfluxDB V2 OSS Alerts : capturing the metric value in notification message

We are monitoring a bunch of IoT Devices using TIG stack and are trying to configure alerts using InfluxDB V2's inbuilt Alerts feature. We have configured the slack notification channel and we would like to capture the metric value as part of the…
RK Kuppala
  • 356
  • 1
  • 2
  • 14
1
vote
1 answer

Efficiently loading large time series data into InfluxDB

I am trying to load 100 billion (thousands of columns, millions of rows) multi-dimensional time series datapoints into InfluxDB from a CSV file. I am currently doing it through line protocol as follows (my codebase is in Python): f = open(args.file,…
1
vote
1 answer

InfluxDB 2.0 - How to merge and sum 2 separate buckets stream in one with Flux

Context I work in an application with influxDB and I am facing a use case I don't know how to solve. I am using influxDB 2 and flux for the queries. Use case To simplify my use case, I'll take an example with bees. I want to measure the evolution of…
Khaaz
  • 11
  • 1
  • 3
1
vote
2 answers

influxDB: How to convert field to tag in influxDB v2.0

We need to convert field to tag in influxDB v2.0 but not able to find any proper solution. Can someone help me out to achieve the same ? Solution we found was to create new measurement by altering fields and tags of existing measurement but not able…
1
vote
1 answer

Problem with multiple devices telegraf nagios plugin

I am trying to add some hosts (UPSs) for monitoring battery charge, invertor status, input voltage, etc. I've been trying to get this working for hours. So, the Nagios scripts seem to work ok and at least some data is logged in influxdb. However,…
1
vote
1 answer

Unable to access Influxdb web UI. It shows 404 page not found error

I have my influxdb working in server. When I try to open the influxdb UI using http://my_host:8086. I'm receiving 404 as response. What am I missing ? help me with this please.
Abilash K
  • 33
  • 1
  • 1
  • 8
1
vote
2 answers

Select one field from a measurement filtered by another fields value in InfluxDB

I'm trying to select a field from a measurement depending on another fields value (with Flux) A SQL-Statement would look like this: SELECT column1 FROM table WHERE column2 > 100; Thx in advance for any help
amigian74
  • 77
  • 1
  • 9
1
vote
1 answer

How to calculate uptime in seconds using Flux?

Using the new Flux langauge, how best to calculate uptime? My current Flux query looks a bit like this: from(bucket: "my-bucket") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r["_measurement"] ==…
roadSurfer
  • 557
  • 1
  • 5
  • 17
1
vote
1 answer

InfluxDB 2.0 unexpected token trying to group by time

So I have data in a bucket in InfluxDB 2.0 I'm in the "Data Explorer" and I'm trying to write a query to see the data that I have inserted. I'm trying a simple query, but I can't seem to make it work, even if I took an example from the…
Danielle Paquette-Harvey
  • 1,691
  • 1
  • 16
  • 31