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

Posted to issues@hive.apache.org by "Hastimal (JIRA)" <ji...@apache.org> on 2017/06/08 18:22:18 UTC

[jira] [Commented] (HIVE-11189) Add 'IGNORE NULLS' to FIRST_VALUE/LAST_VALUE

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

Hastimal commented on HIVE-11189:
---------------------------------

[~prateekrungta] Any update on this ticket?
cc: [~ashutoshc]

> 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.15#6346)