Hello Team,
I am getting below error while i’m trying to join more than 2 measurements using Flux language.
error failed to execute query failed to initialize execute state joins currently must only have two parents
It seems it only allow to join 2 measurements, and not more than two?
This is the flux script I used.
It’s working as expected if am doing with 2 measurements. Kindly help me here.
scott
April 3, 2019, 5:36pm
2
join()
currently supports joining only two input streams (note in the documentation ). You can get around it by joining two streams, then using the resulting output stream in another join.
@scott Thanks, I tried multiple join and it seems working fine as expected.
Actually for InfluxDB version 2 the documentation at https://docs.influxdata.com/influxdb/v2.0/reference/flux/stdlib/built-in/transformations/join/ reads
The join()
function merges two or more input streams whose values are equal on a set of common columns into a single output stream.
but it does not work yet for more than 2.