Clever Geek Handbook

InfluxDB chooses different time between two lines with the same field value

I have a table like this on InfluxDB: +---------------+-----------------+--------+--------------------------+ | time | sequence_number | action | session_id | +---------------+-----------------+--------+--------------------------+ | 1433322591220 | 270001 | delete | 556d85bfe26c3b3864617605 | | 1433322553324 | 250001 | delete | 556d88e4e26c3b3b83c99d32 | | 1433241828472 | 230001 | create | 556d88e4e26c3b3b83c99d32 | | 1433241023633 | 80001 | create | 556d85bfe26c3b3864617605 | | 1433239305306 | 70001 | create | 556d7f09e26c3b34e872b2ba | +---------------+-----------------+--------+--------------------------+

Now I want to find the time range from the session to be created for deletion, which means get time

where the action=delete

minus time

where action=create

if they have the samesession_id

+3
influxdb


source to share


No one has answered this question yet

Check out similar questions:

42
Can you delete data from influxdb?
3
InfluxDB: response time changes for the same request
2
How do I send CSV files to InfluxDB server in the same time series as the time series of CSV files?
2
Get the last stored value at a given time in influenxDB
2
Update time for adduxdb stream in lines
1
select from infuxdb entries where in value range
1
InfluxDB: query to select data from two time ranges simultaneously
1
InfluxDB is a query with an aggregation function DIFFERENCE () that returns a value from another query
0
Exclude time column when selecting a field in CLI INFLUXDB
0
Can Grafana on the same graph choose a different dimension that is in the inflow in a different time range?


More articles:


All Articles
Loading...
X
Show
Funny
Dev
Pics