Skip to content

Conversation

@Lordworms
Copy link
Contributor

Which issue does this PR close?

Closes #11032

Rationale for this change

What changes are included in this PR?

Are these changes tested?

Are there any user-facing changes?

@github-actions github-actions bot added physical-expr Changes to the physical-expr crates optimizer Optimizer rules sqllogictest SQL Logic Tests (.slt) labels Jun 21, 2024
Copy link
Contributor

@alamb alamb left a comment

Choose a reason for hiding this comment

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

Thank you so much @Lordworms

I merged this PR up to main and added a few more tests.

02)--TableScan: dict_table projection=[column1]
physical_plan
01)CoalesceBatchesExec: target_batch_size=8192
02)--FilterExec: column1@0 LIKE %oo%
Copy link
Contributor

Choose a reason for hiding this comment

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

There is no cast! Yay!

@alamb alamb merged commit b872080 into apache:main Jun 23, 2024
@alamb
Copy link
Contributor

alamb commented Jun 23, 2024

Thanks again @Lordworms

findepi pushed a commit to findepi/datafusion that referenced this pull request Jul 16, 2024
* Improve LIKE performance for Dictionary arrays

* fix clippy

* Add a few more tests

---------

Co-authored-by: Andrew Lamb <andrew@nerdnetworks.org>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

optimizer Optimizer rules physical-expr Changes to the physical-expr crates sqllogictest SQL Logic Tests (.slt)

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Improve LIKE performance for Dictionary arrays

2 participants