On Dec 15, 2015, at 08:36, Niels Nes wrote:

On Tue, Dec 08, 2015 at 05:27:58AM +0000, Ashish Kumar Singh wrote:

...

Did anyone got lead and lag functions working with monetdb?

Any test case , examples will be appreciated.

Ashish

Are you looking voor lead/lag as window functions ? Window functions are re-implemented in the default branch (and only a limited set of window functions is currently supported, ie variations on row_number/rank). Currently there is no planning for the additional functions. Also the aggregation functions in the over () case are still missing.

Kan ik him aanbieden via MDBS? Jennie

Niels

...

Sent from Nine

...

_______________________________________________ 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

On Dec 15, 2015, at 10:25, Ying Zhang wrote:

...

On Dec 15, 2015, at 08:36, Niels Nes wrote:

On Tue, Dec 08, 2015 at 05:27:58AM +0000, Ashish Kumar Singh wrote:

...

Did anyone got lead and lag functions working with monetdb?

Any test case , examples will be appreciated.

Ashish

Are you looking voor lead/lag as window functions ? Window functions are re-implemented in the default branch (and only a limited set of window functions is currently supported, ie variations on row_number/rank). Currently there is no planning for the additional functions. Also the aggregation functions in the over () case are still missing.

Kan ik him aanbieden via MDBS?

This shouldn’t have been sent to the list. Apologies! Please ignore. Jennie

Jennie

...

Niels

...

Sent from Nine

...

_______________________________________________ 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