Re: windows function

7 Oct 2015


      Ok thanks, keep up the good work.

On Wed, Oct 7, 2015 at 11:44 AM, Niels Nes  wrote:
...
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  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