[
https://issues.apache.org/jira/browse/HIVE-9412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14567370#comment-14567370
]
Aihua Xu commented on HIVE-9412:
--------------------------------
[~navis] Didn't see you have a jira to work on before and just saw you linked
this to the jira HIVE-10555 I'm working on.
Please note that my changes have been checked in. Could you please mark this as
the duplicate rather than the way around? The good thing is that seems the
implementations are close, no surprise there.
> Window clause ROW BETWEEN for PRECEDING does not work
> -----------------------------------------------------
>
> Key: HIVE-9412
> URL: https://issues.apache.org/jira/browse/HIVE-9412
> Project: Hive
> Issue Type: Bug
> Components: Parser
> Affects Versions: 0.14.0, 0.13.1
> Environment: CDH 5.3 or HDP 2.2
> Reporter: Will Du
> Assignee: Navis
> Attachments: HIVE-9412.1.patch.txt, HIVE-9412.2.patch.txt,
> HIVE-9412.3.patch.txt
>
>
> When window clause with ROWS is used between two proper PRECEDING boundaries,
> Hive reports syntax errors as following examples.
> --For example 1
> SELECT name, dept_num, salary,
> MAX(salary) OVER (PARTITION BY dept_num ORDER BY
> name ROWS BETWEEN 2 PRECEDING AND 1 PRECEDING) win4_alter
> FROM employee_contract;
> Error: Error while compiling statement: 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: Window range invalid, start boundary is greater than end
> boundary: window(start=range(2 PRECEDING), end=range(1 PRECEDING))
> (state=42000,code=40000)
> --For example 2
> SELECT name, dept_num, salary,
> MAX(salary) OVER (PARTITION BY dept_num ORDER BY
> name ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING) win1
> FROM employee_contract;
> Error: Error while compiling statement: FAILED: SemanticException End of a
> WindowFrame cannot be UNBOUNDED PRECEDING (state=42000,code=40000)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
