SUM() OVER (ORDER BY..)

Anthony Damico ajdamico at gmail.com
Fri Apr 29 09:41:30 CEST 2016


hmm, that gives me the same error..

SELECT mpg, wt, SUM(wt) OVER (PARTITION BY hp) AS cum_wgt, SUM(wt) over ()
AS tot_wgt, hp FROM mtcars;


Error in .local(conn, statement, ...) :
  Unable to execute statement 'SELECT
mpg,
wt,
SUM(wt) OVER (PARTITION BY hp) AS cum_wgt,
SUM(wt) over () AS tot_wgt,
hp
FROM mtc...'.
Server says 'ParseException:SQLparser:SELECT: function 'sum' not found'.


sorry if i'm doing something silly..




On Fri, Apr 29, 2016 at 3:37 AM, Roberto Cornacchia <
roberto.cornacchia at gmail.com> wrote:

> I think what you are looking for is SUM(..) OVER(PARTITION BY ..)
>
> Otherwise where would the groups for the sum come from?
>
> Roberto
>
> On 29 April 2016 at 09:28, Anthony Damico <ajdamico at gmail.com> wrote:
>
>> hi, monetdb does not support SUM() OVER commands..  does anyone have a
>> smart alternative to implement this?  thanks
>>
>>
>>     SELECT
>>         batch_id,
>>         job_count,
>>         SUM(job_count) OVER (ORDER BY duration) as cumjobs,
>>         SUM(job_count) over () as totjobs,
>>         duration
>>     FROM
>>         test_data ;
>>
>>
>> _______________________________________________
>> users-list mailing list
>> users-list at monetdb.org
>> https://www.monetdb.org/mailman/listinfo/users-list
>>
>>
>
> _______________________________________________
> users-list mailing list
> users-list at monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20160429/20e02217/attachment.html>


More information about the users-list mailing list