hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dudu Markovitz (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-15402) LAG's PRECEDING does not work.
Date Tue, 25 Apr 2017 07:22:04 GMT

     [ https://issues.apache.org/jira/browse/HIVE-15402?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Dudu Markovitz reassigned HIVE-15402:
-------------------------------------

    Assignee: Dudu Markovitz

> 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
>            Assignee: Dudu Markovitz
>
> 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.3.15#6346)

Mime
View raw message