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
>
|