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
17
votes
3 answers

What are series and bucket in InfluxDb

While trying to understand different concepts of InfluxDb I came across this documentation, where there is a comparision of terms with SQL database. An InfluxDB measurement is similar to an SQL database table. InfluxDB tags are like indexed…
pvpkiran
  • 25,582
  • 8
  • 87
  • 134
16
votes
3 answers

What is the equivalent of SELECT in Flux Query Language?

What would be equivalent flux query for SELECT address, name FROM addresses ? (I am referring to FluxQL, the new query language developed by InfluxData) I didn't find a clear answer to this in the limited Flux Documentation present. Flux…
Sushovan Mandal
  • 1,027
  • 3
  • 13
  • 32
14
votes
6 answers

Grafana - InfluxDB 2 - Label/Alias data

I am in the processing of migrating my panels from using the SQL syntax (from InfluxDB version 1.X) to the new influx syntax (InfluxDB version 2). There is an issue with the labels of the data. It includes the attributes that I used to filter it.…
TheNiceGuy
  • 3,462
  • 8
  • 34
  • 64
8
votes
1 answer

Merging different granularity time series in influxdb

I want to store trades as well as best ask/bid data, where the latter updates much more rapidly than the former, in InfluxDB. I want to, if possible, use a schema that allows me to query: "for each trade on market X, find the best ask/bid on market…
John Dorian
  • 1,884
  • 1
  • 19
  • 29
6
votes
0 answers

Append calculated field (percentage) and combine with results from different datasets, in Influx Flux

I'm struggling with an Influx 2 query in Flux on how to join and map data from two differents sets (tables) into a specific desired output. My current Flux query is this: data = from(bucket: "foo") |> range(start:-1d) |> filter(fn: (r) =>…
Juliën
  • 9,047
  • 7
  • 49
  • 80
6
votes
2 answers

Creating default user for influxdb 2.0 in docker-compose

In previous versions of influxdb we could create an admin user by using the environment variables influxdb: ... environment: INFLUXDB_HOSTNAME: "${INFLUXDB_HOSTNAME}" INFLUXDB_USERNAME: "${INFLUXDB_USERNAME}" …
Bekjan Juma
  • 453
  • 1
  • 5
  • 11
5
votes
2 answers

Get the number of points in a bucket for a time interval with Flux query

Given a bucket how do I get the number of points in this bucket with the timestamp in the given time interval using a Flux query? I'm trying to estimate how much data is added to an influxdb2 bucket per unit of time.
axk
  • 5,316
  • 12
  • 58
  • 96
5
votes
2 answers

Influxdb 2.0 Flux - How to return 0 instead null

I want to count amount of values that are greater than specific value. Data: from(bucket: "bucket name") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r._value > 35) |> count() If there are no values in…
Amerousful
  • 2,292
  • 1
  • 12
  • 26
5
votes
1 answer

Where is the InfluxDB 2.0.2's config file path?

I installed influxdb on my CentOS 8 by a script provided for there: RedHat & CentOS. after I installed it, I don't know which is its config file. this is the result of my search. [root@dele ~]# find / -name…
user7693832
  • 6,119
  • 19
  • 63
  • 114
4
votes
1 answer

flux query very slow in compare to InfluxQL (10x slower)

I'm upgrading form influx1.x to influx2.x (updating queries from influxQL to Flux syntax). For very simple queries, performance drops dramatically when I try to query more than 500,000 points and I'm not sure if there's anything I can do to improve…
Ali Ajouz
  • 61
  • 3
4
votes
1 answer

Influx CLI driving me really crazy, cannot open the CLI

i am installing the influxdb_2.0.9 on my ubuntu, i followed the instructions here: https://docs.influxdata.com/influxdb/v2.0/install/?t=Linux I download it, setup it, i start the influxd daemon, i can connect via browser on localhost:8086, i think i…
Jan Janáček
  • 109
  • 1
  • 9
4
votes
2 answers

Can I query the size of a database in influx db 2

I looked through the influx nodes and I can't find an example of how to get the total size of a particular bucket. Is this possible, I'm using 2.x databases.
Vishal
  • 215
  • 4
  • 14
4
votes
0 answers

Telegraf and Inlfuxdb with docker-compose connection refused

I am trying to set up a Telegraf and Influxdb on macOS 11.3.1 using docker compose. But unfortunately, I am getting the following error: telegraf | 2021-07-12T19:18:14Z E! [outputs.influxdb_v2] When writing to [http://localhost:8086]: Post…
endryha
  • 7,166
  • 8
  • 40
  • 64
4
votes
2 answers

Accessing multiple fields in InfluxDB 2.0 records

im new to InfluxDB 2.0 and am building a time series database where I store multiple fields per Point (price values for XAUUSD currency). While I am able to store it as expected; when I fetch the records, I cant seem to get all the fields accessible…
j_0101
  • 157
  • 4
  • 14
4
votes
0 answers

In Influxdb 2.0, how to find a bucket's size in bytes on disk?

I can certainly find out the size on disk of ALL buckets (du -sh . from the data dir), but it's unclear how I do this for a single bucket because the data doesn't seem organized in the file system by bucket. It would be nice if this info was visible…
tashburn
  • 145
  • 6
1
2 3
…
19 20