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)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to