vegarsti commented on issue #18516:
URL: https://github.com/apache/datafusion/issues/18516#issuecomment-3507604762

   I've pushed https://github.com/apache/datafusion/pull/18561 which adds REE 
to `type_coercion/binary.rs`. I've tried with this repro file and confirmed 
that on main I'm seeing the same error you reported @brancz:  
https://gist.github.com/vegarsti/9c5969008c1ef234edc988220b311dd0
   
   ```
   Running: SELECT * FROM test_table WHERE ree_column = 'test'
   
   Query results:
   Error: Context("type_coercion", Diagnostic(Diagnostic { kind: Error, 
message: "expressions have incompatible types", span: None, notes: 
[DiagnosticNote { message: "has type RunEndEncoded(\"run_ends\": Int32, 
\"values\": nullable Utf8)", span: None }, DiagnosticNote { message: "has type 
Utf8", span: None }], helps: [] }, Plan("Cannot infer common argument type for 
comparison operation RunEndEncoded(\"run_ends\": Int32, \"values\": nullable 
Utf8) = Utf8")))
   ```
   
   However it does not run yet, because the cast support added to arrow-rs in 
https://github.com/apache/arrow-rs/pull/8589 is not available here yet. (I 
haven't confirmed by depending on a more recent arrow-rs version.)
   ```
   Running: SELECT * FROM test_table WHERE ree_column = 'test'
   
   Query results:
   Error: Context("type_coercion", Plan("Cannot automatically convert Utf8 to 
RunEndEncoded(\"run_ends\": Int32, \"values\": nullable Utf8)"))
   ```
   
   FWIW to run this I added it to datafusion-examples so that I could do `cargo 
run --example test_ree_equality --package datafusion-examples`.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to