Hi,
there doesn't seem to be much documentation about how to use lag() in monetdb, and I'm running into a cryptic error. Here is a snippet of a table:
sql>select time, tcp_seq from packet_1_s order by time limit 10; +--------------------------+------------+ | time | tcp_seq | +==========================+============+ | 1436723208.3099999 | 2056936800 | | 1436723208.3099999 | 2056936800 | | 1436723208.3099999 | 2056936800 | | 1436723208.3099999 | 2056936800 | | 1436723208.3099999 | 2056936848 | | 1436723208.3099999 | 2056936848 | | 1436723208.3099999 | 2056936848 | | 1436723208.3099999 | 2056936848 | | 1436723208.3099999 | 2056936896 | | 1436723208.3099999 | 2056936896 | +--------------------------+------------+ 10 tuples (9.701ms)
sql>select time, tcp_seq, lag(tcp_seq, 1) over (order by time) from packet_1_s order by time limit 10; TypeException:user.s22_25[502]:'calc.lag_grp' undefined in: _1678:any := calc.lag_grp(_1672:oid, _1674:oid, _1676:dbl) program contains errors
Any ideas what causes this error?
Thanks, Lars
On Thu, Aug 06, 2015 at 02:32:03PM +0000, Eggert, Lars wrote:
Hi,
there doesn't seem to be much documentation about how to use lag() in monetdb, and I'm running into a cryptic error. Here is a snippet of a table:
sql>select time, tcp_seq from packet_1_s order by time limit 10; +--------------------------+------------+ | time | tcp_seq | +==========================+============+ | 1436723208.3099999 | 2056936800 | | 1436723208.3099999 | 2056936800 | | 1436723208.3099999 | 2056936800 | | 1436723208.3099999 | 2056936800 | | 1436723208.3099999 | 2056936848 | | 1436723208.3099999 | 2056936848 | | 1436723208.3099999 | 2056936848 | | 1436723208.3099999 | 2056936848 | | 1436723208.3099999 | 2056936896 | | 1436723208.3099999 | 2056936896 | +--------------------------+------------+ 10 tuples (9.701ms)
sql>select time, tcp_seq, lag(tcp_seq, 1) over (order by time) from packet_1_s order by time limit 10; TypeException:user.s22_25[502]:'calc.lag_grp' undefined in: _1678:any := calc.lag_grp(_1672:oid, _1674:oid, _1676:dbl) program contains errors
The implementation of lag seems to be missing. I'm in the process of reimplementing most of rank/window related code. Good change this will be in the release after the Jul2015 release.
Niels
Any ideas what causes this error?
Thanks, Lars
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
On 2015-08-06, at 16:40, Niels Nes Niels.Nes@cwi.nl wrote:
The implementation of lag seems to be missing. I'm in the process of reimplementing most of rank/window related code. Good change this will be in the release after the Jul2015 release.
Sorry, newbie here. When you say "seems to be missing", is this the expected situation with a vanilla install of monetdb? Do I need to install any additional packages to enable this? Or does monetdb simply not have lag/lead/etc. at the moment?
Thanks, Lars
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
On 06/08/15 16:45, Eggert, Lars wrote:
On 2015-08-06, at 16:40, Niels Nes Niels.Nes@cwi.nl wrote:
The implementation of lag seems to be missing. I'm in the process of reimplementing most of rank/window related code. Good change this will be in the release after the Jul2015 release.
Sorry, newbie here. When you say "seems to be missing", is this the expected situation with a vanilla install of monetdb? Do I need to install any additional packages to enable this? Or does monetdb simply not have lag/lead/etc. at the moment?
The latter.
Thanks, Lars
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender
On 2015-08-06, at 16:48, Sjoerd Mullender sjoerd@acm.org wrote:
On 06/08/15 16:45, Eggert, Lars wrote:
Sorry, newbie here. When you say "seems to be missing", is this the expected situation with a vanilla install of monetdb? Do I need to install any additional packages to enable this? Or does monetdb simply not have lag/lead/etc. at the moment?
The latter.
Argh. OK, then I'll hope that Niels' code will make it into the Jul2015 release.
Thanks, Lars
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
On 06/08/15 16:53, Eggert, Lars wrote:
On 2015-08-06, at 16:48, Sjoerd Mullender sjoerd@acm.org wrote:
On 06/08/15 16:45, Eggert, Lars wrote:
Sorry, newbie here. When you say "seems to be missing", is this the expected situation with a vanilla install of monetdb? Do I need to install any additional packages to enable this? Or does monetdb simply not have lag/lead/etc. at the moment?
The latter.
Argh. OK, then I'll hope that Niels' code will make it into the Jul2015 release.
It won't. The code isn't there yet, but the release is imminent.
Thanks, Lars
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender
participants (3)
-
Eggert, Lars
-
Niels Nes
-
Sjoerd Mullender