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

Posted to issues@impala.apache.org by "Fang-Yu Rao (Jira)" <ji...@apache.org> on 2025/06/06 01:16:00 UTC

[jira] [Created] (IMPALA-14127) Support IGNORE NULLS for functions

Fang-Yu Rao created IMPALA-14127:
------------------------------------

             Summary: Support IGNORE NULLS for functions
                 Key: IMPALA-14127
                 URL: https://issues.apache.org/jira/browse/IMPALA-14127
             Project: IMPALA
          Issue Type: Sub-task
            Reporter: Fang-Yu Rao
            Assignee: Fang-Yu Rao


Currently the following query that has "{{{}IGNORE NULLS{}}}" as part of the function parameter is not supported by the Calcite planner in Impala. It would be good to support it.
{code:java}
SELECT last_value(tinyint_col IGNORE NULLS) OVER (ORDER BY tinyint_col ASC) FROM functional_parquet.alltypesagg WHERE id < 5
{code}



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