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

ESQL: ProjectAwayColumns rule not handling synthetic attribute correctly #105821

Open
alex-spies opened this issue Feb 27, 2024 · 1 comment · May be fixed by #111413
Open

ESQL: ProjectAwayColumns rule not handling synthetic attribute correctly #105821

alex-spies opened this issue Feb 27, 2024 · 1 comment · May be fixed by #111413
Assignees
Labels
:Analytics/ES|QL AKA ESQL >bug Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)

Comments

@alex-spies
Copy link
Contributor

The logical optimizer rules PushdownEval, PushdownRegexExtract and PushdownEnrich create temporary attributes when an EVAL, GROK/DISSECT or ENRICH is pushed past a SORT with conflicting names; e.g. SORT x | EVAL x = y essentially becomes EVAL $$x = x, x = y | SORT $$x | DROP $$x.

The temporary attribute $$x should be synthetic, but currently that results in inconsistent physical plans as the rule ProjectAwayColumns will wrongly eliminate this attribute from the execution plan.

@elasticsearchmachine elasticsearchmachine added the Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo) label Feb 27, 2024
@elasticsearchmachine
Copy link
Collaborator

Pinging @elastic/es-analytical-engine (Team:Analytics)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
:Analytics/ES|QL AKA ESQL >bug Team:Analytics Meta label for analytical engine team (ESQL/Aggs/Geo)
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants