I am running the following query:
create table employee_contract(
name string,
dept_num int,
salary int
);
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;
I get "FAILED: SemanticException End of a WindowFrame cannot be UNBOUNDED PRECEDING" error message. But the hive documentation states that the window end can be unbounded.
Also there was a jira issue raised.
I am using hdp version 2.6.3.0.