[HIVE-16541] PTF: Avoid shuffling constant keys for empty OVER()

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: PTF-Windowing
• Target Version/s: 3.0.0
• Assignee: Gopal Vijayaraghavan
• Reporter: Gopal Vijayaraghavan
• Created: 26/Apr/17 18:00
• Updated: 13/Jul/17 01:00

Description

Generating surrogate keys with

select row_number() over() as p_key, * from table; 

uses a sorted edge with "0 ASC NULLS FIRST" as the sort order.

Issue Links

• is related to: HIVE-16852 PTF: RANK() re-evaluates order predicates on the reducer