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
2
votes
0 answers

Fetch row based on group and having in influxDB

I'm new at influxDB and trying to solve a query. Where I need to fetch rows based on group by field3 columns and having should count less than 300. I've written it in SQL but not able to fetch any data from influxDB. select count(field1),…
Md Enayat
  • 147
  • 1
  • 12
2
votes
1 answer

InfluxDB 2.0 - Flux query: How to sum a column and use the sum for further calculations

I am new to flux query language (with Influx DB 2) and cant find a solution for the following problem: I have data with changing true and false values: I was able to calculate the time in seconds until the next change by using the events.duration…
JCoordes
  • 147
  • 4
  • 10
2
votes
1 answer

Undefined Identifier Params while using Parameterized Queries for InfluxDB

I am using influxdb-client-java to write and query data from influxdb 2.x. Wanted to write parameterized queries to fetch a list of FluxTable as follows based on sample code from here String bucket = config.getDatabase().getBucket(); Map
Timmy Tseng
  • 35
  • 4
2
votes
1 answer

InfluxDB Unauthorized 401 - with localhost access

When try to write the data into influxDB using influxDB client. i am getting the below error. I was able to login to the influxDB web browser using http://localhost:8086 with the same credentials provided in the code. But facing with the…
learning fun
  • 97
  • 1
  • 1
  • 5
2
votes
1 answer

Influxdb Flux query with custom window aggregate function

Could you please help me with the InfluxDB 2 Flux query syntax to build a windowed query with a custom aggregate function. I went through the online docs, but they seem to be lacking examples on how to get to the actual window content (first, last…
Sergey Shcherbakov
  • 4,534
  • 4
  • 40
  • 65
2
votes
1 answer

How do I convert InfluxDB query to List?

I use the following library for queries from an InfluxDB v2.0. https://github.com/influxdata/influxdb-client-csharp I want to convert the result from the InfluxDB query into a List. I have solved this with the following code. It feels messy to me…
patrickgc
  • 49
  • 7
2
votes
0 answers

Create another admin user in Influx 2.0

How is it possible to create another admin user in Influx 2.0? Lower versions provide the feature directly on creating with an additional "WITH ALL PRIVILEGES". But for Influx 2.0, I cannot find any clue to add a 2nd or even 3rd admin. I can create…
gn0m3r4l
  • 21
  • 2
2
votes
1 answer

InfluxDB 2 introductory sample does not insert any data into the bucket

Once you install InfluxDB, 2 it surfaces a website that includes sample code for various languages. Having created a bucket and a token with RW permissions and selected them, snippets of code with appropriate magic strings are available. Putting…
Peter Wone
  • 17,965
  • 12
  • 82
  • 134
2
votes
0 answers

influxdb 2.0 storage measurements utilization

We have an influxdb 2.0 instance that is quickly growing in size (suspect docker metrics), so I would like to find out which measurements are "spamming". TLDR: how do we find the measurements that take up most of the disk space on influxdb 2.0 Long…
WladyX
  • 21
  • 3
2
votes
1 answer

InfluxDB 2.0 | Query Data and aggregate multiple times

I have a photovolatic system and log the generated electricity in KwH at each change in an InfluxDB 2.0. Now I want to have a graph of the monthly yields in Grafana. For this I need to load the last value of the day and sum it up per month. Actually…
SeeS
  • 21
  • 1
2
votes
1 answer

InfluxDB and Grafana: InfluxDB Error: Bad Request | Docker

I am trying to connect Grafana with InfluxDB, but it throws InfluxDB Error: Bad Request Both i have in docker, and I am using this tutorial where he wrote download and run docker pull influxdb docker run \ -d \ --name influxdb \ -p 8086:8086 \ -e…
Tomáš Mejzr
  • 357
  • 1
  • 5
  • 11
2
votes
2 answers

InfluxDB reports "unauthorized access" with the generated token

I downloaded the latest version of InfluxDB, it's influxdb2-2.0.3_darwin_amd64. I want to write data to the InfluxDB, and followed the documentation of "Use InfluxDB API". I got the "unauthorized access" message. curl --request POST…
choes
  • 141
  • 1
  • 1
  • 11
2
votes
2 answers

Unable to change legend name in Grafana using InfluxDB as Datasource and Flux as query language

Unable to change the legend name in Grafana using InfluxDB[flux as query language]. Previously I was using InfluxQL as query language and at that time, grafana provided an option to set the legend name. But after switching to flux, that option seems…
Akhil
  • 333
  • 3
  • 13
2
votes
3 answers

How to round output values in telegraf?

I'm looking for a way to round the values output from telergaf. Temperature, usage_idle, memory_usage, etc... to 14 decimals is very huge. It too much for me. It can double some of my measurements. I haven't found a way to do it easily. Now I have…
Julien Brdy
  • 93
  • 9
2
votes
2 answers

How to split a string column in two in Flux (InfluxDB)

I have a column of #datatype string which is called names and contains the following info for each row: ABV,BVA BAC,DWA ZZA,DSW ... My question is how can I split (by the comma ,) this column into two columns with names (names_1 and names_2),…
Newskooler
  • 3,973
  • 7
  • 46
  • 84
1 2
3
…
19 20