drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aman Sinha <asi...@maprtech.com>
Subject Re: Window function syntax
Date Fri, 03 Oct 2014 00:50:21 GMT
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 <tnachen@gmail.com> 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 <jinfengni99@gmail.com> 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 <
> > nrentachintala@maprtech.com> 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
> >>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message