hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ratnakar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11189) Add 'IGNORE NULLS' to FIRST_VALUE/LAST_VALUE
Date Fri, 10 Jul 2015 11:31:05 GMT

    [ https://issues.apache.org/jira/browse/HIVE-11189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14622162#comment-14622162
] 

ratnakar commented on HIVE-11189:
---------------------------------

When used with last_value(<col>, true), I am getting all values as "NULL", its not working
correctly.


> 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)

Mime
View raw message