[
https://issues.apache.org/jira/browse/IMPALA-14127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Fang-Yu Rao updated IMPALA-14127:
---------------------------------
Description:
Currently the following query that has "{{{}IGNORE NULLS{}}}" as part of a
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}
was:
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}
> 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
> Priority: Major
>
> Currently the following query that has "{{{}IGNORE NULLS{}}}" as part of a
> 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]
