Try the syntax documented here. This should be standard. http://docs.aws.amazon.com/redshift/latest/dg/c_Window_functions.html
On Thu, Oct 2, 2014 at 4:53 PM, Neeraja Rentachintala < [email protected]> wrote: > 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 >
