[
https://issues.apache.org/jira/browse/HIVE-15402?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16226000#comment-16226000
]
Ryu Kobayashi commented on HIVE-15402:
--------------------------------------
(y)
> LAG's PRECEDING does not work.
> ------------------------------
>
> Key: HIVE-15402
> URL: https://issues.apache.org/jira/browse/HIVE-15402
> Project: Hive
> Issue Type: Bug
> Affects Versions: 2.1.0
> Reporter: Ryu Kobayashi
>
> The syntax in the following manual does not work:
> https://cwiki.apache.org/confluence/display/Hive/LanguageManual+WindowingAndAnalytics#LanguageManualWindowingAndAnalytics-LAGspecifyingalagof3rowsanddefaultvalueof0
> {code}
> SELECT a, LAG(a, 3, 0) OVER (PARTITION BY b ORDER BY C ROWS 3 PRECEDING)
> FROM T;
> {code}
> {code}
> 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
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
