You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@arrow.apache.org by GitBox <gi...@apache.org> on 2021/04/26 13:32:01 UTC
[GitHub] [arrow-datafusion] alamb opened a new issue #185: Add coercion support for `NULL` literals
alamb opened a new issue #185:
URL: https://github.com/apache/arrow-datafusion/issues/185
*Note*: migrated from original JIRA: https://issues.apache.org/jira/browse/ARROW-11851
As we observed in https://github.com/apache/arrow/pull/9565#discussion_r586347165 datafusion won't coerce null literals, forcing strange syntax such as:
```
rpad('hi', CAST(NULL AS INT), 'xy')
We should add automatic coercion logic from the null literal to any type and this expression should work just fine (produce a NULL output)
```
rpad('hi', NULL, 'xy')
```
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [arrow-datafusion] alamb commented on issue #185: Add coercion support for `NULL` literals
Posted by GitBox <gi...@apache.org>.
alamb commented on issue #185:
URL: https://github.com/apache/arrow-datafusion/issues/185#issuecomment-826838192
Comment from Mike Seddon(MikeSeddonAU) @ 2021-03-03T21:52:10.241+0000:
<pre>[~alamb] Previously I implemented the Null=UTF8 type based on the behavior of Postgres not Spark - because the Spark implementation comes with a lot of side effects like the fact that Parquet does not support the `NullType`. We can revisit.</pre>
Comment from Andrew Lamb(alamb) @ 2021-03-04T19:29:54.556+0000:
<pre>Makes sense to me</pre>
--
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org