Neeraja, in the meantime you could add ORDER BY <constant> to your window function if you need to get past the error.
On Thu, Oct 2, 2014 at 5:03 PM, Timothy Chen <[email protected]> wrote: > 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 > >> >
