[
https://issues.apache.org/jira/browse/HIVE-11189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Prateek Rungta updated HIVE-11189:
----------------------------------
Description:
Other RDBMS support the specification of 'IGNORE NULLS' over a paritition to
skip NULL values for Analytic Functions. Example - Oracle's docs:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions057.htm
Please consider adding this to Hive.
was:
Other RDBMS support the specification of 'IGNORE NULLS' over a paritition to
skip NULL values for Analytic Functions. Example - Oracle's docs:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions057.htm
Please considering adding this to Hive.
> Add 'IGNORE NULLS' to FIRST_VALUE/LAST_VALUE
> --------------------------------------------
>
> Key: HIVE-11189
> URL: https://issues.apache.org/jira/browse/HIVE-11189
> Project: Hive
> Issue Type: Improvement
> Components: PTF-Windowing
> Reporter: Prateek Rungta
>
> Other RDBMS support the specification of 'IGNORE NULLS' over a paritition to
> skip NULL values for Analytic Functions. Example - Oracle's docs:
> http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions057.htm
> Please consider adding this to Hive.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
