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

feat(cubesql): Flatten IN lists expressions to improve performance #8235

Merged
merged 12 commits into from
May 14, 2024

Conversation

Nikita-str
Copy link
Contributor

@Nikita-str Nikita-str commented May 6, 2024

Check List

  • Tests has been run in packages where changes made if available
  • Linter has been run for changed code
  • Tests for the changes have been added if not covered yet
  • Docs have been added / updated if required

Partially addresses #6307

after this changes next test fails:
* test_inlist_expr
* test_thoughtspot_where_binary_in_true_false
they fails during `convert_select_to_query_plan` in `LanguageToLogicalPlanConverter::to_logical_plan`: `LogicalPlanLanguage::AllMembers` case `wrapped = false`
@Nikita-str Nikita-str requested a review from a team as a code owner May 6, 2024 13:48
@github-actions github-actions bot added the pr:community Contribution from Cube.js community members. label May 6, 2024
Copy link

vercel bot commented May 6, 2024

The latest updates on your projects. Learn more about Vercel for Git ↗︎

8 Ignored Deployments
Name Status Preview Comments Updated (UTC)
examples-angular-dashboard ⬜️ Ignored (Inspect) Visit Preview May 14, 2024 9:42am
examples-react-d3 ⬜️ Ignored (Inspect) Visit Preview May 14, 2024 9:42am
examples-react-dashboard ⬜️ Ignored (Inspect) Visit Preview May 14, 2024 9:42am
examples-react-data-table ⬜️ Ignored (Inspect) Visit Preview May 14, 2024 9:42am
examples-react-highcharts ⬜️ Ignored (Inspect) Visit Preview May 14, 2024 9:42am
examples-react-material-ui ⬜️ Ignored (Inspect) Visit Preview May 14, 2024 9:42am
examples-react-pivot-table ⬜️ Ignored (Inspect) Visit Preview May 14, 2024 9:42am
examples-vue-query-builder ⬜️ Ignored (Inspect) Visit Preview May 14, 2024 9:42am

fix works only when literals isn't null

prev rule wasn't correct in case when `expr IN list` is FALSE
and test the case by SQL_PUSH_DOWN
@Nikita-str Nikita-str changed the title fix(cubesql): flatten IN list expr to performance & IS (NOT) NULL rewrite rules fix(cubesql): flatten IN list expr to performance May 8, 2024
@paveltiunov paveltiunov changed the title fix(cubesql): flatten IN list expr to performance feat(cubesql): Improve flatten IN list expr performance May 13, 2024
@paveltiunov paveltiunov changed the title feat(cubesql): Improve flatten IN list expr performance feat(cubesql): Flatten IN lists expressions to improve performance May 13, 2024
@Nikita-str Nikita-str merged commit 66aa01d into master May 14, 2024
76 checks passed
@Nikita-str Nikita-str deleted the С964-flatten-IN-list-expr branch May 14, 2024 10:39
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
pr:community Contribution from Cube.js community members.
Projects
None yet
Development

Successfully merging this pull request may close these issues.

None yet

2 participants