Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Influxdb2 - Data Explorer Flux - Suggested join methods {left, right, cross.... } not implemented #5089

Closed
karel-rehor opened this issue Feb 18, 2019 · 1 comment

Comments

@karel-rehor
Copy link

Build nightly
Buildtime 2019-02-18T07:08:51

ts=2019-02-18T12:06:28.681294Z lvl=info msg="Welcome to InfluxDB" log_id=0Dh7qxIG000 version=nightly commit=cbef811c6 build_date=2019-02-18T07:08:51Z

Use Case

  1. Create test data
  2. Open Data explorer > Script editor
  3. Create a flux script using join
Smichov = from(bucket: "test-data")
  |> range(start: -4h)
  |> filter(fn: (r) => r._measurement == "air_quality")
  |> filter(fn: (r) => r.location == "Smichov") 
  |> filter(fn: (r) => r._field == "SO2")
  |> drop(columns: ["gps", "label", "location", "unitId" ])
  
Hlavni = from(bucket: "test-data")
  |> range(start: -4h)
  |> filter(fn: (r) => r._measurement == "air_quality")
  |> filter(fn: (r) => r.location == "Praha hlavni") 
  |> filter(fn: (r) => r._field == "SO2")
  |> drop(columns: ["gps", "label", "location", "unitId" ])
  
  
join(tables: {key1: Smichov, key2: Hlavni}, on: ["city", "_field", "_measurement", "_start", "_stop", "_time" ], method: "inner")

Note that when adding the join function the tooltip document suggests other types of joins are possible (e.g. left, right, cross, full)

  1. Change the join method from "inner" to "left" and click submit.

An error message indicates that "left is not a valid join type".

Question

I realize that this is pre-beta. Is there any idea of when the other join methods will be supported? And, if they are not supported at next release. shouldn't the tooltip document reflect currently supported possibilities?

Screenshot

fluxdejoin01
fluxdejoin02
fluxdejoin03

@russorat
Copy link
Contributor

please follow this issue to see when other join types will be added: influxdata/flux#84

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants