Skip to content

Add setting optimize_move_to_prewhere_if_final#25940

Merged
kssenii merged 4 commits intoClickHouse:masterfrom
kssenii:move-to-prewhere-if-final
Jul 4, 2021
Merged

Add setting optimize_move_to_prewhere_if_final#25940
kssenii merged 4 commits intoClickHouse:masterfrom
kssenii:move-to-prewhere-if-final

Conversation

@kssenii
Copy link
Copy Markdown
Member

@kssenii kssenii commented Jul 3, 2021

I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en

Changelog category (leave one):

  • Improvement

Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):
Added setting optimize_move_to_prewhere_if_final. If query has FINAL, the optimization move_to_prewhere will be enabled only if both optimize_move_to_prewhere and optimize_move_to_prewhere_if_final are enabled. Closes #8684.

@robot-clickhouse robot-clickhouse added the pr-improvement Pull request with some product improvements label Jul 3, 2021
@alexey-milovidov
Copy link
Copy Markdown
Member

@Mergifyio update

@mergify
Copy link
Copy Markdown
Contributor

mergify bot commented Jul 3, 2021

Command update: success

Branch has been successfully updated

@alexey-milovidov alexey-milovidov self-assigned this Jul 3, 2021
}
}

bool InterpreterSelectQuery::moveToPrewhereIfFinal()
Copy link
Copy Markdown
Member

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Let's rename to shouldMoveToPrewhere and also include the check settings.optimize_move_to_prewhere inside the function.

@kssenii kssenii merged commit 9b4d35e into ClickHouse:master Jul 4, 2021
@gyuton
Copy link
Copy Markdown
Contributor

gyuton commented Jul 15, 2021

Internal documentation ticket: DOCSUP-11547.

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

Labels

pr-improvement Pull request with some product improvements

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Need to disable optimize_move_to_prewhere if query has FINAL.

4 participants