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

Flux queries of influxdb tags (keys(), tag groups) should allow push-downs of filters including _field in the predicate #21171

Open
lesam opened this issue Apr 8, 2021 · 1 comment
Labels

Comments

@lesam
Copy link
Contributor

lesam commented Apr 8, 2021

Proposal:
Flux queries corresponding to influxql meta-queries (show tag keys, show tag values) should support filtering by _field (the field name) efficiently. There is a performance improvement for these filters implemented in 2.x OSS that we would like to be back ported to 1.x.

See the tests proposed in https://github.com/influxdata/influxdb/pull/21160/files for how this feature would look.

Note the implementation in that PR would need to change somewhat to be compatible with InfluxDB Enterprise. Ideally the influxql backend could be shared by both flux and influxql - this would require improvements to the influxql metaquery backend.

Current behavior:
Flux queries over influxdb tag keys and values that otherwise could be pushed down to the storage engine and made more efficient will instead use less-efficient strategies when the filter() contains _field.

Desired behavior:
We would like these queries to be maximally efficient

Alternatives considered:
N/A.

Use case:
Filtering tag keys and values by which field keys they show up with.

@lesam lesam changed the title Flux meta-queries (keys(), tag groups) should allow push-downs of filters including _field in the predicate Flux queries of influxdb tags (keys(), tag groups) should allow push-downs of filters including _field in the predicate Apr 8, 2021
@lesam
Copy link
Contributor Author

lesam commented Apr 8, 2021

See also the 2.x changes for this: #19856 , #19894

@lesam lesam added the 1.x label Apr 8, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant