[
https://issues.apache.org/jira/browse/ARROW-16718?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17561086#comment-17561086
]
Ian Cook commented on ARROW-16718:
----------------------------------
FYI, Substrait has an {{is_not_distinct_from}} comparison function:
https://github.com/substrait-io/substrait/blob/1080f06298d8e50abcd6acfaa6c425326a7e0579/extensions/functions_comparison.yaml#L21
> [C++] Implement is_distinct_from and is_not_distinct_from kernels
> -----------------------------------------------------------------
>
> Key: ARROW-16718
> URL: https://issues.apache.org/jira/browse/ARROW-16718
> Project: Apache Arrow
> Issue Type: New Feature
> Components: C++
> Reporter: Ian Cook
> Priority: Minor
>
> Some SQL engines have the comparison operators {{IS DISTINCT FROM}} and
> {{{}IS NOT DISTINCT FROM{}}}. These are so-called {_}null-safe comparison
> operators{_}.
> As explained in the Impala docs:
> {quote}The IS DISTINCT FROM operator, and its converse the IS NOT DISTINCT
> FROM operator, test whether or not values are identical. IS NOT DISTINCT FROM
> is similar to the = operator, and IS DISTINCT FROM is similar to the !=
> operator, except that NULL values are treated as identical. Therefore, IS NOT
> DISTINCT FROM returns true rather than NULL, and IS DISTINCT FROM returns
> false rather than NULL, when comparing two NULL values. If one of the values
> being compared is NULL and the other is not, IS DISTINCT FROM returns true
> and IS NOT DISTINCT FROM returns false, again instead of returning NULL in
> both cases.
> {quote}
> It would be a nice convenience to have these implemented as kernels in Arrow.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
