Omri,

Were you ever able to get this to work?

From: users-list [mailto:users-list-bounces+david.b.anderson=citi.com@monetdb.org] On Behalf Of Omri Schwarz
Sent: Friday, October 20, 2017 5:45 PM
To: Communication channel for MonetDB users
Subject: RE: Proper syntax for a windowing function

Thank you. I've been trying all sorts of queries, but notice  the avg function becoming unavailable the moment I try a windowing operation?

---

From: users-list [users-list-bounces+ocschwar=mit.edu@monetdb.org] on behalf of Corbit, Dann [Dann.Corbit@softwareag.com]
Sent: Friday, October 20, 2017 5:07 PM
To: Communication channel for MonetDB users
Subject: RE: Proper syntax for a windowing function

https://www.monetdb.org/Documentation/Manuals/SQLreference/WindowFunctions

From: users-list [mailto:users-list-bounces+dann.corbit=softwareag.com@monetdb.org] On Behalf Of Omri Schwarz
Sent: Friday, October 20, 2017 1:46 PM
To: users-list@monetdb.org
Subject: Proper syntax for a windowing function

Hi, all. I'm trying to figure out the proper syntax for queries such as a moving average over a window in MonetDB.

THis works:

sql>select avg(energy) from TABLENAME;
+--------------------------+
| L3                       |
+==========================+
|        658.5049567388747 |
+--------------------------+

This fails:

select avg(energy) OVER () from TABLENAME;
SELECT: function 'avg' not found

(Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2017-SP1)
Database: MonetDB v11.27.5 (Jul2017-SP1), 'mapi:monetdb://SERVER2:50000/scada' )

How do I write such a query?

Many thanks.