Stack Overflow
Stack Overflow

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
1 answer

An item with the same key has already been added. Key: result from a call to InfluxDB

I am testing write/query time series data to/from InfluxDB v2 using c#. Basically I used pretty much the example provided in the WebInterface under Data->"Load Data"->"Client Libraries"->C#. I can write to the database no problem but when I try to…
stackoverblown
  • 734
  • 5
  • 10
1
vote
1 answer

InfluxDB Flux join series

I have following data in influxdb server,operation=ADD queryMs=7.9810 1620608972904452000 server,operation=GET queryMs=12.2430 1620608972909339200 server,operation=UPDATE queryMs=11.5780 1620608972909655400 server,operation=ADD queryMs=11.2460…
Tima
  • 141
  • 1
  • 6
1
vote
0 answers

Need help converting InfluxQL query to InfluxDB2 Flux

I’m trying to figure out how to convert a rather simple influxql query to influxdb2 flux but I just can’t find the correct way. This is the query: SELECT NON_NEGATIVE_DERIVATIVE(MEAN(transmit), 10s) as transmit,…
Flexburo
  • 81
  • 4
1
vote
1 answer

InfluxDb as sublocation behind traefik on localhost using docker, Ubuntu 20.04

since the last two days I am trying to set up a traefik instance which can access the dashboard of my influxdb 2.0 instance via localhost/influx tl;dr The route is working fine. The problem occurs when the initial request is returned as 200-OK it…
exa.byte
  • 155
  • 1
  • 12
1
vote
0 answers

InfluxDB optimize storage for 2.7 billion series and more

We're looking to migrate some data into InfluxDB. I'm working with InfluxDB 2.0 on a test server to determine the best way to stock our data. As of today, I have about 2.7 billion series to migrate to InfluxDB but that number will only go up. Here…
Danielle Paquette-Harvey
  • 1,691
  • 1
  • 16
  • 31
1
vote
0 answers

Influxdb 2.0 Backup Fails with Read:authorizations is unauthorized

I am trying to backup influxdb using backup command as stated in v2.0 doc. https://docs.influxdata.com/influxdb/v2.0/backup-restore/backup/ docker-compose.yaml version: '3' services: influxdb: image: influxdb:2.0 ports: - 8086:8086 …
Anish
  • 1,920
  • 11
  • 28
  • 48
1
vote
1 answer

How to download influxdb2.0 data in csv format?

I am not familiar with influxdb command line especially influxDB2.0. so I choose to use InfluxDB 8086 port frontend. but I found if want to download .csv by frontend, too many data leads to browser collapse, which at last leads to download…
Frank Liu
  • 11
  • 1
1
vote
1 answer

InfluxDB - limit query result by number of series using Flux

I'm trying to query my InfluxDB (1.8) using Flux and retrieve only 100 series, at first I thought the "limit" function will do it, however, I found out it only limits the number of records in each table (series) which can result in max(100) *…
Shahar Sadkovich
  • 110
  • 7
1
vote
0 answers

Getting Attribute value of InlfuxDB Measurment attribute in .net core 3.1

This week I started developing with the InfluxDB.Client.Core package in one of my .net core 3.1 applications. Everything works fine following tutorials and reading docs like those of the package:…
E. Verdi
  • 310
  • 2
  • 19
1
vote
2 answers

How to replace an empty InfluxDB query result with a single value for the single stat visualization

I'm using the new InfluxDB2 and the flux query language to retrieve docker stats from my bucket. I want to display the uptime of a container in a single stat widget. For this I use the following query: from(bucket: "docker") |> range(start:…
totkeks
  • 89
  • 2
  • 9
1
vote
0 answers

How does sample function work in InfluxDB

I tried to use sample() function in influxDB to get random dataset from it. I want to know more about the internal working of the sample() function present in InfluxDB, like does it scan the whole measurement(table) to get the random subsets from it…
Priyansh Bhadviya
  • 23
  • 3
1
vote
1 answer

how to start influxdb 2.0.2?

ok I installed (in ubuntu 20.04) as it said the official page of influxdb https://portal.influxdata.com/downloads/, specifically these commands: wget https://dl.influxdata.com/influxdb/releases/influxdb_2.0.2_amd64.deb sudo dpkg -i…
hyper carly
  • 21
  • 1
  • 4
1
vote
1 answer

How can I transform InfluxDB GROUP results based on the different rows in the result tables using Flux

I'm trying to perform a transform on the results of a Flux group operation. I need to derive a value based on the values of individual rows. Source query: from('bucket') |> ... filters, etc |> group() |> sort() returns data with the following…
Byron Ross
  • 1,595
  • 1
  • 14
  • 21
1
vote
1 answer

InfluxDB2.0: How to sum up multiple time series with irregular time interval?

TL;DR I'm using Influxdb v2.0 and use the Influx query syntax (as in the GUI). I'm having multiple series (same _field, different tag) of digital 0/1 state, and I want to sum them up. The problem is that the state is stored in the database with…
Blue_Togepi
  • 41
  • 1
  • 8
1
vote
1 answer

How to query data from InfluxDB using Node.js

I am working on a project where I have an InfluxDB bucket that has a measurement of elapsedtime and a tag of service. I want to query Influx to be able to get all datapoints in the last 1 hour for foobar as the service. Ideally I will add a time…
joshk132
  • 1,011
  • 12
  • 37
1 2 3
…
19 20