drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob Rumsby <brum...@maprtech.com>
Subject Re: Window function syntax
Date Fri, 03 Oct 2014 00:00:32 GMT
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 <
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