drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Timothy Chen <tnac...@gmail.com>
Subject Re: Window function syntax
Date Fri, 03 Oct 2014 00:02:48 GMT
Do you get errors on both? Optiq is doing the SQL parsing so it's
whatever format that Optiq accepts.

Tim

On Thu, Oct 2, 2014 at 5:00 PM, Bob Rumsby <brumsby@maprtech.com> wrote:
> 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
View raw message