[HIVE-15402] LAG's PRECEDING does not work.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 2.1.0
• Assignee: Unassigned
• Reporter: Ryu Kobayashi
• Created: 09/Dec/16 05:33
• Updated: 30/Oct/17 23:47
• Resolved: 30/Oct/17 23:47

Description

The syntax in the following manual does not work: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics#LanguageManualWindowingAndAnalytics-LAGspecifyingalagof3rowsanddefaultvalueof0

SELECT a, LAG(a, 3, 0) OVER (PARTITION BY b ORDER BY C ROWS 3 PRECEDING)
FROM T;

FAILED: SemanticException Failed to breakup Windowing invocations into Groups. At least 1 group must only depend on input columns. Also check for circular dependencies.
Underlying error: Expecting left window frame boundary for function LAG((tok_table_or_col a), 3, 0) Window Spec=[PartitioningSpec=[partitionColumns=[(tok_table_or_col b)]orderColumns=[(tok_table_or_col c) ASC NULLS_FIRST]]window(start=range(3 PRECEDING), end=currentRow)] as LAG_window_0 to be unbounded. Found : 3