Hi folks, The window clause in Hive 0.13.* does not work for the following example statement
- BETWEEN 2 PRECEDING AND 1 PRECEDING - BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING Is there a reported JIRA for this? If not, I'll create Jira for this. Thanks, Will jdbc:hive2://> 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 . . . . . . .> ORDER BY dept_num, name; 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) jdbc:hive2://> 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 . . . . . . .> ORDER BY dept_num, name; Error: Error while compiling statement: FAILED: SemanticException End of a WindowFrame cannot be UNBOUNDED PRECEDING (state=42000,code=40000)
