Invalid Import path while performing join


When I try to perform a join as shown below

import “array”
import “influxdata/influxdb/Sample”
import “join”

left = “First”)
|> filter(fn: (r) => r.Sno == 61 or r.Sno == 62 or r.Sno == 63)
|> filter(fn: (r) => r._field == “Second”)
|> limit(n: 5)

right =
rows: [
{Sno: 61, State: “AP”, last_maintained: 2023-04-08T00:00:00Z},
{Sno: 62, State: “KA”, last_maintained: 2023-04-08T00:00:00Z},

left: left |> group(),
right: right,
on: (l, r) => l.Sno == r.Sno,
as: (l, r) => ({l with State: r.State, maintained: r.last_maintained}),
|> group(columns: [“State”])

It is giving an error as “Invalid import path join error”.


Hello @AVVS_Sudheer,
What version of InfluxDB are you using?
Please make sure to verify that you’re using the right version of InfluxDB in the Flux docs.

Click on the View InfluxDB support to verify that your version supports the package.