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

What's the logical connection between buckets, measurements & retention policies in InfluxDB 2.0?

I am currently studying the documentation of InfluxDB 2.0; however, I don't understand the logic between buckets, measurements & retention policies entirely yet. The documentation says that databases and retention policies got replaced with buckets.…
2
votes
1 answer

Do different Retention Policies (RP) behave like tables when Querying with Flux?

I would like to query the same measurement across different retention policies into a single graph. Ideally, I'd like to do this in the query itself, as I'm working with Grafana. According to Flux documentation, "Flux structures all data in tables.…
M0llzilla
  • 33
  • 5
2
votes
3 answers

`missing tag key` when inserting to InfluxDB with inserting with multiple tags

I created a new db mydb on Influxdb. Next I did use mydb When I run insert on my db, I run into error - ERR: {"error":"unable to parse 'angle, userid=1, product=pname value=5.1': missing tag key"} Here's the insert that I am running - INSERT…
nkirit
  • 379
  • 2
  • 4
  • 13
1
vote
1 answer

InfluxDB metrics is visible in frontend UI. How to restrict it?

We have installed the InfluxDB time series database and we would like to restrict users to access /metrics /debug/pprof/all and several other sensitive URLs which don't require login. Can someone please suggest a way how we can restrict them apart…
RSSAH
  • 123
  • 14
1
vote
2 answers

Sum values based on Timestamp for InfluxDb (Flux)

I have data for executions running on different machines(Agents). The data is…
1
vote
0 answers

InfluxDB fill(linear) only intervals lesser than x minutes

I need to fill in missing data in an InfluxDB query grouped by 10 seconds, using linear interpolation (fill(linear)), but only if the gap between data points is less than 10 minutes. For any gaps longer than that, I want the query to either return…
Ruuza
  • 185
  • 7
1
vote
1 answer

unable to write in influxdb2 using pandas dataframe

I am trying to write data from a panda's dataframe to influxdb v2.2 using python. However, I am not seeing any data in query. import pandas as pd from influxdb_client import InfluxDBClient from influxdb_client.client.write_api import…
1
vote
2 answers

Error: "pod has unbound immediate PersistentVolumeClaims"

While installing influxdb2 using k8s manifest from the link influxdb2 installation on k8s I get below "pod has unbound immediate PersistentVolumeClaims" error. The instruction is given for minikube but I am installing it as a normal k8s…
1
vote
1 answer

Flux Query : join.inner() returns nothing if I don't limit my stream used

I get an issue understanding how to use the join.inner() function. It seems I can only have a result (and the correct one) if I use the limit() function to the stream I want to use the join.inner function with. If don't limit this left stream, I…
Kratheon
  • 21
  • 4
1
vote
0 answers

Query data based on condition in InfluxDB

I'm fresher level person in influxDB and I strongly believe that this query is little hard to me. So before starting my question, first I'm showing my snippets Measurement: Power time id level wp1 wp2 wp3 ---- --…
Md Enayat
  • 147
  • 1
  • 12
1
vote
2 answers

Flux Query : iterate filter from a list

I search a way to filter by a loop/iterate from a list is it possible? The table tophdd contains 2 entries, but i can't filter these two entries with a regex. tophdd = from(bucket: v.bucket) |>range(start: v.timeRangeStart, stop:…
greg
  • 33
  • 5
1
vote
1 answer

InfluxDB 2 / influxdb-client-java: Long data is written but String value is read. ClassCastException occurred

InfluxDB v2.5.1 influxdb-client-java 6.7.0 Java POJO @Data @Builder @NoArgsConstructor @AllArgsConstructor @Measurement(name = "my_measurement") public class MyMeasurement { @Column(timestamp = true) private Instant time; @Column(name…
Jiruffe
  • 47
  • 5
1
vote
0 answers

Flux left join on empty table

I'm looking to join two data streams together but receive the following error from Influx: error preparing right side of join: cannot join on an empty table I'm trying to build a query which compares the total sales by a store this month compared to…
1
vote
0 answers

Find the correct grouping

I'll first try to describe the non-technical problem: There are many services, each service can have multiple instances and each of those instances is scraped for data and that data is stored in influxdb. Now the point in time where that data is…
Chris
  • 7,675
  • 8
  • 51
  • 101
1
vote
0 answers

influxdb2 and nginx reverse proxy

I have installed influxdb2 from their website and setup nginx according to this amazing guide from digitalocean. I am trying to set a reverse proxy in order to query and post data to the db. I have my own URL and have set A records and a wildcard. I…
grayred8
  • 93
  • 6