influxdata / flux

Flux is a lightweight scripting language for querying databases (like InfluxDB) and working with data. It's part of InfluxDB 1.7 and 2.0, but can be run independently of those.
https://influxdata.com
MIT License
769 stars 153 forks source link

join two table streams issue with flux #5427

Closed tbs575 closed 1 year ago

tbs575 commented 1 year ago

I have two table streams one is image

another is image

try to join two tables stream with following flux

join.left(
    left: leftdata,
    right: rightdata,
    on: (l, r) => l.source_ip == r.source_ip,
    as: (l, r) => ({C: r.source_country}),
)

but can not get anything, should be retrun country information, is there problem? thanks image

MarcoPignati commented 1 year ago

try playing with grouping the tables before joining them. I rememeber there was something in the docs about the need of grouping

github-actions[bot] commented 1 year ago

This issue has had no recent activity and will be closed soon.