Ah, I thought I reported on Optiq (Calcite) already but I think I might have forgot about it.
Thanks for finding this out! Tim On Thu, Oct 2, 2014 at 5:01 PM, Jinfeng Ni <[email protected]> wrote: > 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 >>
