On Wed, Oct 07, 2015 at 11:21:00AM +0300, imad hajj chahine wrote:
> Thank You Niels,
>
> What other options do i have to support these type of functions? is it
> a good decision to use Pyhton and R language function to overcome this
> shortage or I stick to traditional SQL turnaround.
Imad

The current limitation of the rank function also applies to R and
Python. Once we have time also these language extensions will better
support the (new) Rank interface.
Sorry for this (probably) disappointing answer ...

Niels

>
> Imad.
>
> On Wed, Oct 7, 2015 at 10:25 AM, Niels Nes <Niels.Nes@cwi.nl> wrote:
>
>     On Tue, Oct 06, 2015 at 07:57:07PM +0300, imad hajj chahine wrote:
>     > Hi,
>     >
>     > Since monetdb support window RANK functions, is it possible to
>     extend
>     > the sql library to support also window aggregate function like
>     SUM, AVG
>     > ... useful for running total and moving average.
>     >
>     > Any plan to support this in the near future or the implementation
>     is
>     > easy to be done with user defined functions.
>     >
>     > Thanks.
>     Imad
>
>     In the default the window functions have be reimplemented. This is
>     the
>     first step towards more support for window functions including the
>     aggregate functions. Unfortunately we are al time constraint to
>     make
>     much progress on this.
>
>     niels
>
>     > _______________________________________________
>     > users-list mailing list
>     > users-list@monetdb.org
>     > https://www.monetdb.org/mailman/listinfo/users-list
>
>
>     --
>     Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI)
>     Science Park 123, 1098 XG Amsterdam, The Netherlands
>     room L3.14,  phone ++31 20 592-4098     sip:4098@sip.cwi.nl
>     url: https://www.cwi.nl/people/niels    e-mail: Niels.Nes@cwi.nl
>     _______________________________________________
>     users-list mailing list
>     users-list@monetdb.org
>     https://www.monetdb.org/mailman/listinfo/users-list
>
>

> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list


--
Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14,  phone ++31 20 592-4098     sip:4098@sip.cwi.nl
url: https://www.cwi.nl/people/niels    e-mail: Niels.Nes@cwi.nl
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list