-
Notifications
You must be signed in to change notification settings - Fork 1.3k
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
Error: There isn't a common type to coerce Binary and Utf8 in LIKE expression #7342
Comments
Marking as a good first issue as there is a reproducer and I think the fix should be relatively straightforward |
Working on a fix |
I looked into this issue a little bit. Looks like there needs to be changes in |
I am not quite sure I think that Thus, a better approach might be to try and automatically coerce (cast) the |
Describe the bug
On running the 4 queries below on the Clickbench multi file dataset,
we get this error,
type_coercion caused by Error during planning: There isn't a common type to coerce Binary and Utf8 in LIKE expression
To Reproduce
Download the data using,
A
hits_multi
directory with the parquet files will be created.Execute the above queries,
Expected behavior
The queries should run successfully without erroring.
Additional context
Datafusion 29.0.0
The text was updated successfully, but these errors were encountered: