Responsive Ad Area

Share This Post

test

Extract only variables which is greater than other table in influxDB

I am using influxDB and I would like to extract some values which is greater than certain threshold in other table.

For example, I have two tables as shown in below.

Table A

Time     value
1         15
2         25
3         9
4         22

Table B

Time     threshold
1         16
2         12
3         13
4         15

Give above two tables, I would like to extract three values which is greater than first row in Table B. Therefore what I want to have is as below.

   Time     value
    2         25
    4         22

I tried it using below sql query, but it didn’t give any correct result.

select * from TABLE_A where value > TABLE_B.threshold limit 1

Look forward to your feedback.

Thanks.


Extract only variables which is greater than other table in influxDB
Extract only variables which is greater than other table in influxDB
test
{$excerpt:n}

Share This Post

Leave a Reply

Your email address will not be Publishedd. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Skip to toolbar