Window function syntax

[Neeraja Rentachintala]

I want to try out the window function syntax in Drill (playing with latest
build).
Does the below look accurate. I currently hit an error with this syntax.



SELECT employee_id,position_id, salary, avg(salary) OVER w from
cp.`employee.json` window w as (partition by position_id)

SELECT employee_id,position_id, salary, avg(salary) OVER (PARTITION BY
position_id) FROM cp.`employee.json`;


Error:

Query failed: Failure while setting up Foreman. null
[7f63c4cc-f9f8-460b-98d5-6324c11e095b]



-thanks

Neeraja