Stack Overflow
Stack Overflow

Questions tagged [influxql]

Use this tag for questions related to InfluxQL, an SQL-like query language for interacting with data in InfluxDB.

219 questions
0
votes
1 answer

Influx - How to get time division data when data reset to 0

I using Grafana and influxdb to collect ‘product data’ in the assembly line. I make a chat by grafana to show how many products was done in every hour. It works good, but i have one problem, sometimes the worker will clear the total count because…
Elan.Cao
  • 75
  • 10
0
votes
1 answer

Is it possible to check on a InfluxDB database when a record is missing?

I have a problem concerning an InfluxQL request. Here the thing, I have a database and I want to get the id of my device or the value 0 when it does not send bytes during an hour. Here is an example of the structure of my database time …
clecleath
  • 1
0
votes
1 answer

Exclude measurements using regex in influxql

I have an influxql query used in grafana as follows: SELECT mean("value") FROM /^concourse\.(worker*|web*).*\.system_mem_percent$/ WHERE $timeFilter GROUP BY time($__interval), * fill(null) This works as expected, I get only the results of…
Vipin Menon
  • 2,892
  • 4
  • 20
  • 35
0
votes
1 answer

InfluxQL to new task FLUX with resample and group

I 6 hour try convert influxQL to FLUX query. Any can do it ? CREATE CONTINUOUS QUERY trade_to_candles_60 ON mydb RESAMPLE EVERY 10s FOR 10m BEGIN SELECT first(price) AS open, last(price) AS close, max(price) AS high, min(price) AS low, sum(amount)…
padavan
  • 714
  • 8
  • 22
0
votes
1 answer

can you have multiple aggregators in a promQL query

In influxQL you can do queries with multiple aggregation functions like this: SELECT MEAN(value), MIN(value) FROM measurement WHERE category= ... In promQl you can specify an aggregation function as well, like Avg: Avg by (server)…
eng007
  • 93
  • 2
  • 8
0
votes
1 answer

Grafana Dashboard for Jmeter

I am new to InfluxDB & Grafana. Currently we are performing load testing with Jmeter (5.2.1) and also utilizing InfluxDB (2.0) & Grafana for monitoring. The set up goes like - 1 Controller machine and 8 remote host machines (LGs). Though we are…
Nike
  • 23
  • 1
  • 10
0
votes
2 answers

SQL Query to count entries in the column and get percentage

student have new books alice yes bob yes candace no dalia no edd no frank yes expected output 50 essentially i want to count the total number of rows and and students that have new books and get the percentage of students with…
Foo Chan Onn
  • 1
  • 1
0
votes
0 answers

What's wrong on this influxdb delete?

Deleting the influxdb entries which have some value for particular field and field exist in the entry. delete from stats_io where _field='read_val' This query doesn't throw any error and it doesn't delete any entries as well. But the field exist in…
Rajan
  • 416
  • 1
  • 7
  • 25
0
votes
0 answers

Influx Query with lots of select or better approach

I am sorry if this quest sounds like something simple. But, I have just begun to work with Influx. I have the following data set in my influx DB. > select * from "productA" where "key" = 'auth-service' and time >= now() - 2d name: productA time …
Mike
  • 512
  • 3
  • 16
0
votes
1 answer

Influxdb: How can I modify all values in a field? (divide current value by 100,000)

I have a lot of pressure data registered in Pa, but it should be in Bar (100,000 Pa). How can I modify all values in a field in my Influxdb to be divided by 100,000? What I would have done in MariaDB: UPDATE table SET pressure = pressure / 100000
Øyvind
  • 103
  • 5
0
votes
1 answer

InfluxDB - 2.0 - stand alone DB

I am using Influxdb with Grafana for a while and I like it. I am confused with the new version of Influxdb2.0. I was searching the doc and could not find useful info. I have some questions. Will Influxdb be available only as bundled with db + ui as…
KitKarson
  • 5,211
  • 10
  • 51
  • 73
0
votes
2 answers

InfluxDB v2 compatibility endpoint /query not working after mapping unmapped buckets

Creating an InfluxQL datasource in Grafana to InfluxDB 2.0 (2.0.0-beta.16) failed with error: can't assign to property "executedQueryString" on "
EagleJohn81
  • 11
  • 1
  • 3
0
votes
1 answer

Influxdb GroupBy time uses predefined intervals and does not start with the first timestamp

I am using Influxdb to store some data representing requests being made to certain services. I want to calculate the number of requests done in one second in a time interval of 5 seconds (multiple requests might happen in one second). In order to…
Ciprian Nazarie
  • 36
  • 7
0
votes
1 answer

how to get latest timestamp data

I am new to influx db, please help me with query? I have below like data in influx where same Name data (A1, A2) can be available for multiple time. I need only latest time stamp data (row 3,4,5) if same data is available in multiple time stamp and…
user584018
  • 10,186
  • 15
  • 74
  • 160
0
votes
1 answer

InfluxDB: Is flux the only way to add simple calculations as a column in a query?

I'm trying a query like so: SELECT COUNT("value"), F("value"),G("value") FROM "someTable" WHERE time >= t1 AND time < t2 GROUP BY (aggregateWindow),* F = sum of squares, and this wouldn't be too hard if I could do something like the following…
Isaac
  • 204
  • 2
  • 10
1 2 3
…
14 15