developers-list-request-d/
2012-10-16 10:00:01 UTC
This message was forwarded from developers-list-d/***@public.gmane.org The MonetDB
mailing lists have moved to monetdb.org. Please subscribe to
developers-list-d/***@public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/developers-list
Send developers-list mailing list submissions to
developers-list-d/***@public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/developers-list
or, via email, send a message with subject or body 'help' to
developers-list-request-d/***@public.gmane.org
You can reach the person managing the list at
developers-list-owner-d/***@public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of developers-list digest..."
Today's Topics:
1. ANSI SQL 2003 Extension OVER() appears to be missing in
MonetDB Click to flag this post (James Becker III)
2. Re: ANSI SQL 2003 Extension OVER() appears to be missing in
MonetDB Click to flag this post (Niels Nes)
----------------------------------------------------------------------
Message: 1
Date: Mon, 15 Oct 2012 17:55:10 +0000
From: James Becker III <jbecker-***@public.gmane.org>
To: "developers-list-d/***@public.gmane.org" <developers-list-d/***@public.gmane.org>
Subject: ANSI SQL 2003 Extension OVER() appears to be missing in
MonetDB Click to flag this post
Message-ID: <CCA1C63C.2E30%jbecker-***@public.gmane.org>
Content-Type: text/plain; charset="us-ascii"
Hello MonetDB Community.
My name is James Becker, my friends call me Jaimi, and I am new to posting messages here, so I hope you will bear with me.
I am conducting a POC on MonetDB to see if we can use it to replace Vertica for a large scale read mostly educational reporting application. So far things are showing promise, but the legacy reports lean heavily on OVER(), which doesn't appear to be part of the 11.11.11 release. Am I missing something, or is this the case?
If anyone who has run into a similar limitations has any insights as to where I have made a wrong turn, or how to either implement OVER() in MonetDB using either MAL/C, or any suggestions for query work-arounds that would yield similar results, this would be greatly appreciated.
Thx.
~jj
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/developers-list/attachments/20121015/7629c148/attachment.html>
------------------------------
Message: 2
Date: Mon, 15 Oct 2012 21:13:44 +0200
From: Niels Nes <Niels.Nes-rh8NL+***@public.gmane.org>
To: "Communication channel for developers of the MonetDB suite."
<developers-list-d/***@public.gmane.org>
Subject: Re: ANSI SQL 2003 Extension OVER() appears to be missing in
MonetDB Click to flag this post
Message-ID: <20121015191344.GC5881-+7+HFsgkf2oxr/***@public.gmane.org>
Content-Type: text/plain; charset="utf-8"
OVER is supported, but no all of its functionality. Could specify which
functions you would like to use with over? Also which windowing
limitations would be required?
We sofar focused on the row_number and rank functions.
Niels
Niels Nes, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14, phone ++31 20 592-4098 sip:4098-3SA25f8um+Dz+***@public.gmane.org
url: http://www.cwi.nl/~niels e-mail: Niels.Nes-rh8NL+***@public.gmane.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://mail.monetdb.org/pipermail/developers-list/attachments/20121015/8cdba51d/attachment.sig>
------------------------------
_______________________________________________
developers-list mailing list
developers-list-d/***@public.gmane.org
http://mail.monetdb.org/mailman/listinfo/developers-list
End of developers-list Digest, Vol 2, Issue 5
*********************************************
mailing lists have moved to monetdb.org. Please subscribe to
developers-list-d/***@public.gmane.org, and unsubscribe from this list.
See: http://mail.monetdb.org/mailman/listinfo/developers-list
Send developers-list mailing list submissions to
developers-list-d/***@public.gmane.org
To subscribe or unsubscribe via the World Wide Web, visit
http://mail.monetdb.org/mailman/listinfo/developers-list
or, via email, send a message with subject or body 'help' to
developers-list-request-d/***@public.gmane.org
You can reach the person managing the list at
developers-list-owner-d/***@public.gmane.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of developers-list digest..."
Today's Topics:
1. ANSI SQL 2003 Extension OVER() appears to be missing in
MonetDB Click to flag this post (James Becker III)
2. Re: ANSI SQL 2003 Extension OVER() appears to be missing in
MonetDB Click to flag this post (Niels Nes)
----------------------------------------------------------------------
Message: 1
Date: Mon, 15 Oct 2012 17:55:10 +0000
From: James Becker III <jbecker-***@public.gmane.org>
To: "developers-list-d/***@public.gmane.org" <developers-list-d/***@public.gmane.org>
Subject: ANSI SQL 2003 Extension OVER() appears to be missing in
MonetDB Click to flag this post
Message-ID: <CCA1C63C.2E30%jbecker-***@public.gmane.org>
Content-Type: text/plain; charset="us-ascii"
Hello MonetDB Community.
My name is James Becker, my friends call me Jaimi, and I am new to posting messages here, so I hope you will bear with me.
I am conducting a POC on MonetDB to see if we can use it to replace Vertica for a large scale read mostly educational reporting application. So far things are showing promise, but the legacy reports lean heavily on OVER(), which doesn't appear to be part of the 11.11.11 release. Am I missing something, or is this the case?
If anyone who has run into a similar limitations has any insights as to where I have made a wrong turn, or how to either implement OVER() in MonetDB using either MAL/C, or any suggestions for query work-arounds that would yield similar results, this would be greatly appreciated.
Thx.
~jj
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.monetdb.org/pipermail/developers-list/attachments/20121015/7629c148/attachment.html>
------------------------------
Message: 2
Date: Mon, 15 Oct 2012 21:13:44 +0200
From: Niels Nes <Niels.Nes-rh8NL+***@public.gmane.org>
To: "Communication channel for developers of the MonetDB suite."
<developers-list-d/***@public.gmane.org>
Subject: Re: ANSI SQL 2003 Extension OVER() appears to be missing in
MonetDB Click to flag this post
Message-ID: <20121015191344.GC5881-+7+HFsgkf2oxr/***@public.gmane.org>
Content-Type: text/plain; charset="utf-8"
Hello MonetDB Community.
My name is James Becker, my friends call me Jaimi, and I am new to
posting messages here, so I hope you will bear with me.
I am conducting a POC on MonetDB to see if we can use it to replace
Vertica for a large scale read mostly educational reporting
application. So far things are showing promise, but the legacy reports
lean heavily on OVER(), which doesn't appear to be part of the 11.11.11
release. Am I missing something, or is this the case?
If anyone who has run into a similar limitations has any insights as to
where I have made a wrong turn, or how to either implement OVER() in
MonetDB using either MAL/C, or any suggestions for query work-arounds
that would yield similar results, this would be greatly appreciated.
Thx.
~jj
JamesMy name is James Becker, my friends call me Jaimi, and I am new to
posting messages here, so I hope you will bear with me.
I am conducting a POC on MonetDB to see if we can use it to replace
Vertica for a large scale read mostly educational reporting
application. So far things are showing promise, but the legacy reports
lean heavily on OVER(), which doesn't appear to be part of the 11.11.11
release. Am I missing something, or is this the case?
If anyone who has run into a similar limitations has any insights as to
where I have made a wrong turn, or how to either implement OVER() in
MonetDB using either MAL/C, or any suggestions for query work-arounds
that would yield similar results, this would be greatly appreciated.
Thx.
~jj
OVER is supported, but no all of its functionality. Could specify which
functions you would like to use with over? Also which windowing
limitations would be required?
We sofar focused on the row_number and rank functions.
Niels
_______________________________________________
developers-list mailing list
http://mail.monetdb.org/mailman/listinfo/developers-list
--developers-list mailing list
http://mail.monetdb.org/mailman/listinfo/developers-list
Niels Nes, Centrum Wiskunde & Informatica (CWI)
Science Park 123, 1098 XG Amsterdam, The Netherlands
room L3.14, phone ++31 20 592-4098 sip:4098-3SA25f8um+Dz+***@public.gmane.org
url: http://www.cwi.nl/~niels e-mail: Niels.Nes-rh8NL+***@public.gmane.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: not available
URL: <http://mail.monetdb.org/pipermail/developers-list/attachments/20121015/8cdba51d/attachment.sig>
------------------------------
_______________________________________________
developers-list mailing list
developers-list-d/***@public.gmane.org
http://mail.monetdb.org/mailman/listinfo/developers-list
End of developers-list Digest, Vol 2, Issue 5
*********************************************