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
How do I get structured data when querying data from influxdb in python?
I've been entering data as fields to the influxdb. when i'm querying data, I"m not getting them as a table like I would when I query in SQL. Is there any way i can get a list of dictionaries like i did when i inserted data to the db.
for…
0
votes
1 answer
Return a LIMITed number of Prometheus samples between START and END timestamps
I want to get at most limit raw samples from a Prometheus metric, starting at a start time and stopping before an end time (in case limit is greater than the number of samples between start and end). With InfluxQL, this is straightforward:
SELECT…
Dan Dascalescu
- 143,271
- 52
- 317
- 404
0
votes
1 answer
InfluxQL: Calculate periode of status change
I have a table in my InfluxDB for a parking sensor which sends a state for occupied (1) and vacant (9).
Now I want to create a query which shows me the time period between the status changes so that I can create a report for the time the parkingslot…
derw0lf
- 1
0
votes
1 answer
InfluxDB JSON data ingestion into a measurement
I am trying to ingest the data from one measurement (vulnerability) to another measurement (test1) using influxDB python client. Since i want to ingest only server, ID, route from vulnerability measurement into test1 measurement, i choose three…
peter
- 17
- 5
0
votes
1 answer
InfluxDB where query on tag values
I am trying to write a where clause on InfluxDB where the points are filtered via their key values.
My points have the field ping_to_google.com and the tag key user where user can be raspi-2 or raspi-5. This is a sample output of the database:
>…
Bat
- 771
- 11
- 29
0
votes
1 answer
Influxdb time range query
I am trying to form a sql query for the below condition in where clause but it is giving an error.
date(\"time\") BETWEEN date_trunc('month', current_date - INTERVAL '1 months') \
AND (date_trunc('MONTH', current_date - INTERVAL '1…
svw1105
- 127
- 1
- 15
0
votes
1 answer
InfluxdDB query - select field from multiple measuremnts
I'm trying to get an exact field from multiple measurements with the same naming pattern.
Let's say the measurements are like:
some.stats.123
some.stats.456
some.stats.789
I'm trying to get test value, this is possible with:
select test from…
Wiktor Kisielewski
- 31
- 1
- 5
0
votes
1 answer
Influx QL Variables Integer and Variable Embedding Not working
I was trying to write a simple FluxQL Query in Grafana Dashboard that uses a variable
m1(of type constant)(which contains the name of the measurement)
I created the variable m1 in grafana dashboard variables
m1 = my-measurement
and tried to run the…
Nimish Bansal
- 23
- 2
0
votes
1 answer
Is there a way to automatically increment the dates in my InlfuxQL query?
I have a Grafana dashboard , version v8.1.6 (4a4083716c),where I display the output voltage, current and power of a solar panel. I am using the watt2kwh node to convert my power reading that is in Watt to Watt-Hour. The interval between successive…
Rohan
- 21
- 5
0
votes
1 answer
How to join influx db queries
I have a Influx db (V1.8- FLUX disabled by hoster). I want to "add" a column to the measurement which uses the estimated function.
Initial Measurement look like:
time Current state_string
---- -------…
renzop
- 1,194
- 2
- 12
- 26
0
votes
0 answers
How to show only latest value in influx-db&Grafana?
I am trying to run a dashboard with influxdb and grafana and i would like to show only the latest values of each id e.g. if i have a table something like this
id
utime
2
9:10AM
3
9:20AM
2
9:30AM
2
9:35AM
4
9:40AM
4
9:50AM
Now I…
Hsn
- 1,168
- 2
- 16
- 39
0
votes
1 answer
InfluxDB 2.0 How to find out how many queries are being executed
I'm using InfluxDB 2.0. Looking to go to the cloud in production when all my testing is done. I'm trying to evaluate the amount of queries my load is going to generate.
I would like to be able to know how much queries are generated by specific load…
Danielle Paquette-Harvey
- 1,691
- 1
- 16
- 31
0
votes
2 answers
InfluxQL: how to read one value and its derivative
I am stuck with an issue with InfluxDB.
I would like to show a value with its derivative.
If I try the following:
SELECT DERIVATIVE(value) FROM (SELECT value FROM MyValues WHERE "f"='myfield')
...I get the derivative values. If I try the…
chx
- 31
- 2
0
votes
1 answer
Influxdb database names with space creating issues
There are some databases created inside my influxdb and the names of the databases have space in-between.
I can't able to use those databases using the CLI command use and hence I can't able to see any series out of it.
I have tried…
Subarna Samanta
- 15
- 2
0
votes
0 answers
InfluxDB replace null values with 0
I am having an issue with InfluxDB...
I have some timeseries data for host availability. The issue is that, when the host is down, nothing is sent onto Influx, so the values for these timestamps are null.
If I use fill(0) when selecting the…
