Do you get errors on both? Optiq is doing the SQL parsing so it's whatever format that Optiq accepts.
Tim On Thu, Oct 2, 2014 at 5:00 PM, Bob Rumsby <[email protected]> wrote: > 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 >>
