I think this has been reported in https://issues.apache.org/jira/browse/DRILL-1450.
I have a temp fix, where code fix is in optiq side. But I have not build a patch yet. Need more testing. 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 >
