[Influxdb 1.6]: Use Inner join request

Store
1

Hello,

Does influxDB handle “inner join requests” ? I’m using version 1.6 and “inner join queries” are not working.
In the near future, will influxdb handle this kind of request?

If the answer is no, is there an alternative to “inner join” queries ?

Thanks in Advance,

Regard’s,

Chris.

2

Hello @chrisH,
If you use 1.7.6 and above you can use flux.
With flux you can use joins and specify the method type with
method:String
The method used to join. Possible values are: inner, cross, left, right, or full. Defaults to "inner".

Here is the spec and the documentation

3

Hello @Anaisdg,

Thank you for your reply. now i’m going to upgrade my influxdb and do some join query tests.

Regard’s,

Chris.

4

Hello @Anaisdg,

I migrated influxdb to version 1.7.6. I tried an inner join query and still have the same error.

select AVERAGE.value + RT.value from AVERAGE inner join RT where AVERAGE.host = ‘admang’ and RT.host = ‘admang’;
ERR: error parsing query: found inner, expected ; at line 1, char 46

regard’s

Chris.

5

Hello @chrisH,

You can’t use influxql to perform inner joins. You have to use flux. Please look at the spec or the documentation link above for flux query examples.

6

Hello @Anaisdg,

Thank you for your reply. I will study the documentation and do tests later.

Regard’s,

Chris.

1 Like