Join conflict in InfluxDB 2.7

InfluxDB 2
,
1

I am using InfluxDB 2.7.0 and trying to perform the outer join.

import "join"
import "sql"

left =
    my_query

right =
    my_query2

join.full(
    left: left,
    right: right,
    on: (l, r) => l.id== r.id,
    as: (l, r) => {
        id = if exists l.id then l.id else r.id
        
        return {name: l.name, location: r.location, id: id}
    },
)

This query is working fine.
But when I am writing the query

output2 = join(
    tables: {d1: left , d2: right},
    on: ["tag1","tag2"],
)

This join is not working.
But when I remove import "join" 2nd join also works fine.

Is there any difference between these two join?

but in InfluxDB 2.4.0 first join is not working but second join is working fine.

Why this conflict is happening? is it expected?

Thanks

2

You cannot use the older join() if you use the join library. import "join"

you should use instead join.inner()

image
image981×451 27 KB