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:03:40 GMT
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
View raw message