[HIVE-11189] Add 'IGNORE NULLS' to FIRST_VALUE/LAST_VALUE

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: PTF-Windowing
• Assignee: Unassigned
• Reporter: Prateek Rungta
• Created: 07/Jul/15 02:43
• Updated: 08/Jun/17 18:21

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.