Use this tag for questions related to InfluxQL, an SQL-like query language for interacting with data in InfluxDB.
Questions tagged [influxql]
219 questions
0
votes
1 answer
InfluxDB' request Select where time > timestamp
I have a java application that send measurements to an influxDB database.
I am adding points within my influxdb database.
The points that I add each time that my program run have the current timestamp.
This is how I am adding my points (measurement…
Aymen Ragoubi
- 298
- 5
- 22
0
votes
1 answer
I can not get the latest records in query to influxdb
I have a query in influxql to get cpu, memory, load and disk values with a WHERE clause to indicate that it only brings the data from 1 minute ago. The query works but it always brings the same date, that is, the exact date of the WHERE. I need…
Avellino
- 61
- 7
0
votes
1 answer
InfluxQL modulo operator on WHERE clause for timestamp `now()` function
I want to query my records from today at 00.00 to now(). The problem is that I want to do this dynamically so I need to manipulate the timestamp using now() function.
Here is the query as an example.
SELECT SUM("something")
FROM…
wisn
- 974
- 10
- 17
0
votes
1 answer
Segment aggregate value by time while applying function to previous data points
Some basic stuff: I'm trying to create a "running" query where for every datapoint, I get the mean & count up to that point, alongside the value. For instance for these measurements:
hunger=1 1001
hunger=3 1002
hunger=5 1003
hunger=20 1004
I want…
kuzyn
- 1,905
- 18
- 30
0
votes
1 answer
InfluxDB: Group rows with same timestamp
Assume a DB with the following data records:
2018-04-12T00:00:00Z value=1000 [series=distance]
2018-04-12T00:00:00Z value=10 [series=signal_quality]
2018-04-12T00:01:00Z value=1100 [series=distance]
2018-04-12T00:01:00Z value=0 …
theDmi
- 17,546
- 6
- 71
- 138
0
votes
1 answer
How can I get distribution of filed's value in influx db
I use influx db to save my website's performance data。The data in my influx db like below:
//mock data
time load
---- ----
2018-11-27T08:34:46.899z 262
2018-11-27T08:35:46.899z …
kkdev163
- 31
- 3
0
votes
0 answers
How to return N most "heavy" requests
We have InfluxDb database with request measurement, it contains url tag and duration field.
I need to select top 5 slowest requests (average).
I can write similar sql-query for sql server:
select top 5 url, avg_duration
FROM (
select url,…
Alex T
- 2,067
- 4
- 20
- 27
0
votes
1 answer
Integral function in InfluxDB not returning any data
I'm trying to get a graph total power usage for specific periods of time (e.g. by hour). Currently my power data is stored in an influxdb database every 6 seconds.
I can get a graph of the current usage using the mean function, but using the…
Jazzy J
- 302
- 1
- 15
-1
votes
1 answer
Pull data from dynamic measurement name by uisng InfluxQL query
In my application I am showing metrics to grafana from influxdb. I have dynamic name in influxdb db. e.g. customer_info_{customerId}.
My question is in influxQL query how can I use dynamic measurement name so I can display metrics from it.
ppb
- 2,299
- 4
- 43
- 75