InfluxDB select different time between two row having same a field value -


i have table 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 | +---------------+-----------------+--------+--------------------------+ want find time range session created deleted, means time action=delete minus time action=create if have same session_id


Comments