Support Questions
Find answers, ask questions, and share your expertise

SemanticException End of a WindowFrame cannot be UNBOUNDED PRECEDING error

Highlighted

SemanticException End of a WindowFrame cannot be UNBOUNDED PRECEDING error

New Contributor

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.