You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@arrow.apache.org by "Ian Cook (Jira)" <ji...@apache.org> on 2022/07/15 16:10:00 UTC

[jira] [Created] (ARROW-17090) [C++] Add null_if kernel

Ian Cook created ARROW-17090:
--------------------------------

             Summary: [C++] Add null_if kernel
                 Key: ARROW-17090
                 URL: https://issues.apache.org/jira/browse/ARROW-17090
             Project: Apache Arrow
          Issue Type: Improvement
          Components: C++
            Reporter: Ian Cook


Add a binary kernel {{null_if(x, y)}} that returns {{null}} if {{x}} equals {{y}} , otherwise returns {{x}}.

This function is commonly found in many databases and query engines and is typically named {{nullif}}. For example: [PostgreSQL|https://www.postgresql.org/docs/15/functions-conditional.html#FUNCTIONS-NULLIF], [Impala|https://impala.apache.org/docs/build/html/topics/impala_conditional_functions.html#conditional_functions__nullif], [Snowflake|https://docs.snowflake.com/en/sql-reference/functions/nullif.html].



--
This message was sent by Atlassian Jira
(v8.20.10#820010)