[I] coalesce on RunEndEncoded column fails to plan [datafusion]

["asubiotto (via GitHub)" <gi...@apache.org>]

asubiotto opened a new issue, #21918:
URL: https://github.com/apache/datafusion/issues/21918

   ### Describe the bug
   
   `coalesce(REE_column, literal)` fails to plan when one argument is a `RunEndEncoded` column and another is a non-REE literal. The same failure occurs for any expression routed through `type_union_resolution` (`UNION`, `NULLIF`, `CASE`, etc.).
   
   ```
   Function 'coalesce' user-defined coercion failed with: Execution error:
   Fail to find the coerced type, errors: Execution error:
   Expect to get struct but got RunEndEncoded("run_ends": non-null Int32, "values": Utf8).
   No function matches the given name and argument types
   'coalesce(RunEndEncoded("run_ends": non-null Int32, "values": Utf8), Utf8)'.
   ```
   
   ### To Reproduce
   
   ```sql
   CREATE TABLE ree_t AS
   SELECT arrow_cast(c, 'RunEndEncoded("run_ends": non-null Int32, "values": Utf8)') AS ree_col
   FROM (VALUES ('hello'), (NULL), ('world')) AS t(c);
   
   SELECT coalesce(ree_col, '__null__') FROM ree_t;
   ```
   
   ### Expected behavior
   
   ```
   hello
   __null__
   world
   ```


-- 
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: github-unsubscribe@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org

Re: [I] coalesce on RunEndEncoded column fails to plan [datafusion]

["Jefffrey (via GitHub)" <gi...@apache.org>]

Jefffrey closed issue #21918: coalesce on RunEndEncoded column fails to plan
URL: https://github.com/apache/datafusion/issues/21918


-- 
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: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org