Fwd: Using the inet and url type functions

newer
Possible to reset or flush out RAM...

Christopher Nelson

23 May 2013 23 May '13

1:35 p.m.

Hi, I noticed in the manual that there are many useful functions for the inet and url types. For example, I would like to convert an inet column to text for use in a Python script (since the python-monetdb module does not support the inet type.) I tried: sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5;syntax error, unexpected '(', expecting SCOLON in: "select wlid, text(" sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; unexpected symbol (:) sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; syntax error, unexpected '(', expecting SCOLON in: "select wlid, inet.text(" I have read through the manual sections on types and functions several times now, and I cannot see how to use the specified functions on these types. Any help would be greatly appreciated. Thanks! -={C}=-

Attachments:

attachment.html (text/html — 2.1 KB)

Show replies by date

Niels Nes

23 May 23 May

6:33 p.m.

On Thu, May 23, 2013 at 09:35:01AM -0400, Christopher Nelson wrote:

...

Hi,

I noticed in the manual that there are many useful functions for the inet and url types. For example, I would like to convert an inet column to text for use in a Python script (since the python-monetdb module does not support the inet type.)

I tried:

sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5;syntax error, unexpected '(', expecting SCOLON in: "select wlid, text("

Text is a monetdb sql keyword, ie simply double quote text. ie SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; Niels

...

sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; unexpected symbol (:)

sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; syntax error, unexpected '(', expecting SCOLON in: "select wlid, inet.text("

I have read through the manual sections on types and functions several times now, and I cannot see how to use the specified functions on these types. Any help would be greatly appreciated.

Thanks!

-={C}=-

...

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

Christopher Nelson

6:35 p.m.

sql>SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; SELECT: no such unary operator 'text(inet)' On Thu, May 23, 2013 at 2:33 PM, Niels Nes wrote:

...

On Thu, May 23, 2013 at 09:35:01AM -0400, Christopher Nelson wrote:

...
Hi,

I noticed in the manual that there are many useful functions for the inet and url types. For example, I would like to convert an inet column to text for use in a Python script (since the python-monetdb module does not support the inet type.)

I tried:

sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5;syntax error, unexpected '(', expecting SCOLON in: "select wlid, text("

Text is a monetdb sql keyword, ie simply double quote text.

ie

SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5;

Niels

...
sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; unexpected symbol (:)

sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; syntax error, unexpected '(', expecting SCOLON in: "select wlid, inet.text("

I have read through the manual sections on types and functions several times now, and I cannot see how to use the specified functions on these types. Any help would be greatly appreciated.

Thanks!

-={C}=-

...
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Niels Nes

6:41 p.m.

On Thu, May 23, 2013 at 02:35:59PM -0400, Christopher Nelson wrote:

...

sql>SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; SELECT: no such unary operator 'text(inet)'

The text function should be part of the 14_inet.sql file which is loaded the first time you start (the first) client. Which version are you running? Niels

...

On Thu, May 23, 2013 at 2:33 PM, Niels Nes wrote:

On Thu, May 23, 2013 at 09:35:01AM -0400, Christopher Nelson wrote: > Hi, > > I noticed in the manual that there are many useful functions for the > inet and url types. For example, I would like to convert an inet column > to text for use in a Python script (since the python-monetdb module > does not support the inet type.) > > I tried: > > sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS NOT NULL ORDER > BY src, ts LIMIT 5;syntax error, unexpected '(', expecting SCOLON in: > "select wlid, text("

Text is a monetdb sql keyword, ie simply double quote text.

ie

SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5;

Niels > > sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src IS NOT NULL > ORDER BY src, ts LIMIT 5; > unexpected symbol (:) > > sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src IS NOT NULL > ORDER BY src, ts LIMIT 5; > syntax error, unexpected '(', expecting SCOLON in: "select wlid, > inet.text(" > > I have read through the manual sections on types and functions several > times now, and I cannot see how to use the specified functions on these > types. Any help would be greatly appreciated. > > Thanks! > > -={C}=- > >

> _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

...

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Christopher Nelson

6:45 p.m.

cnelson@hpvm:/store/meps/db $ mclient -v mclient, the MonetDB interactive terminal (Feb2013-SP2) support for command-line editing compiled-in character encoding: UTF-8 cnelson@hpvm:/store/meps/db $ sudo monetdb version MonetDB Database Server Toolkit v1.1 (Feb2013-SP2) On Thu, May 23, 2013 at 2:41 PM, Niels Nes wrote:

...

On Thu, May 23, 2013 at 02:35:59PM -0400, Christopher Nelson wrote:

...
sql>SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5; SELECT: no such unary operator 'text(inet)'

The text function should be part of the 14_inet.sql file which is loaded the first time you start (the first) client. Which version are you running?

Niels

...
On Thu, May 23, 2013 at 2:33 PM, Niels Nes wrote:

On Thu, May 23, 2013 at 09:35:01AM -0400, Christopher Nelson wrote: > Hi, > > I noticed in the manual that there are many useful functions for the > inet and url types. For example, I would like to convert an inet column > to text for use in a Python script (since the python-monetdb module > does not support the inet type.) > > I tried: > > sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS NOT NULL ORDER > BY src, ts LIMIT 5;syntax error, unexpected '(', expecting SCOLON in: > "select wlid, text("

Text is a monetdb sql keyword, ie simply double quote text.

ie

SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL ORDER BY src, ts LIMIT 5;

Niels > > sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src IS NOT NULL > ORDER BY src, ts LIMIT 5; > unexpected symbol (:) > > sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src IS NOT NULL > ORDER BY src, ts LIMIT 5; > syntax error, unexpected '(', expecting SCOLON in: "select wlid, > inet.text(" > > I have read through the manual sections on types and functions several > times now, and I cannot see how to use the specified functions on these > types. Any help would be greatly appreciated. > > Thanks! > > -={C}=- > >

> _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

...
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Niels Nes

6:55 p.m.

On Thu, May 23, 2013 at 02:45:27PM -0400, Christopher Nelson wrote:

...

cnelson@hpvm:/store/meps/db $ mclient -v mclient, the MonetDB interactive terminal (Feb2013-SP2) support for command-line editing compiled-in character encoding: UTF-8

cnelson@hpvm:/store/meps/db $ sudo monetdb version MonetDB Database Server Toolkit v1.1 (Feb2013-SP2)

...

On Thu, May 23, 2013 at 2:41 PM, Niels Nes wrote:

On Thu, May 23, 2013 at 02:35:59PM -0400, Christopher Nelson wrote: > sql>SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL > ORDER BY src, ts LIMIT 5; > SELECT: no such unary operator 'text(inet)'

The text function should be part of the 14_inet.sql file which is loaded the first time you start (the first) client. Which version are you running?

Niels > > > > On Thu, May 23, 2013 at 2:33 PM, Niels Nes wrote: > > On Thu, May 23, 2013 at 09:35:01AM -0400, Christopher Nelson wrote: > > Hi, > > > > I noticed in the manual that there are many useful functions for > the > > inet and url types. For example, I would like to convert an inet > column > > to text for use in a Python script (since the python-monetdb > module > > does not support the inet type.) > > > > I tried: > > > > sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS NOT NULL > ORDER > > BY src, ts LIMIT 5;syntax error, unexpected '(', expecting SCOLON > in: > > "select wlid, text(" > > Text is a monetdb sql keyword, ie simply double quote text. > > ie > > SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL > ORDER > BY src, ts LIMIT 5; > > Niels > > > > sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src IS NOT > NULL > > ORDER BY src, ts LIMIT 5; > > unexpected symbol (:) > > > > sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src IS NOT > NULL > > ORDER BY src, ts LIMIT 5; > > syntax error, unexpected '(', expecting SCOLON in: "select wlid, > > inet.text(" > > > > I have read through the manual sections on types and functions > several > > times now, and I cannot see how to use the specified functions on > these > > types. Any help would be greatly appreciated. > > > > Thanks! > > > > -={C}=- > > > > > > > _______________________________________________ > > users-list mailing list > > users-list@monetdb.org > > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl > url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl > > _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-list > > >

> _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

...

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Christopher Nelson

7:58 p.m.

...

On Thu, May 23, 2013 at 02:45:27PM -0400, Christopher Nelson wrote:

...
cnelson@hpvm:/store/meps/db $ mclient -v mclient, the MonetDB interactive terminal (Feb2013-SP2) support for command-line editing compiled-in character encoding: UTF-8

cnelson@hpvm:/store/meps/db $ sudo monetdb version MonetDB Database Server Toolkit v1.1 (Feb2013-SP2)

Could you do a

sql>select * from functions where name = 'text';

Should result in the following

+------+------+---------------------------+------+-------+------+-------+------+ | id | name | func | mod | sql | type | side_ | sche | : : : : : : : effec : ma_i : : : : : : : : t : d :

+======+======+===========================+======+=======+======+=======+======+ | 5246 | text | create function "text" (p | inet | true | 1 | false | 2000 | : : : inet) returns clob : : : : : : : : : external name inet."text : : : : : : : : : "; : : : : : :

+------+------+---------------------------+------+-------+------+-------+------+ 1 tuple (3.183ms) sql>

Niels

...
On Thu, May 23, 2013 at 2:41 PM, Niels Nes wrote:

On Thu, May 23, 2013 at 02:35:59PM -0400, Christopher Nelson wrote: > sql>SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL > ORDER BY src, ts LIMIT 5; > SELECT: no such unary operator 'text(inet)'

The text function should be part of the 14_inet.sql file which is loaded the first time you start (the first) client. Which version are you running?

Niels > > > > On Thu, May 23, 2013 at 2:33 PM, Niels Nes wrote: > > On Thu, May 23, 2013 at 09:35:01AM -0400, Christopher Nelson wrote: > > Hi, > > > > I noticed in the manual that there are many useful functions for > the > > inet and url types. For example, I would like to convert an inet > column > > to text for use in a Python script (since the python-monetdb > module > > does not support the inet type.) > > > > I tried: > > > > sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS NOT NULL > ORDER > > BY src, ts LIMIT 5;syntax error, unexpected '(', expecting SCOLON > in: > > "select wlid, text(" > > Text is a monetdb sql keyword, ie simply double quote text. > > ie > > SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT NULL > ORDER > BY src, ts LIMIT 5; > > Niels > > > > sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src IS NOT > NULL > > ORDER BY src, ts LIMIT 5; > > unexpected symbol (:) > > > > sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src IS NOT > NULL > > ORDER BY src, ts LIMIT 5; > > syntax error, unexpected '(', expecting SCOLON in: "select wlid, > > inet.text(" > > > > I have read through the manual sections on types and functions > several > > times now, and I cannot see how to use the specified functions on > these > > types. Any help would be greatly appreciated. > > > > Thanks! > > > > -={C}=- > > > > > > > _______________________________________________ > > users-list mailing list > > users-list@monetdb.org > > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl > url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl > > _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-list > > >

> _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

...
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Niels Nes

8:51 p.m.

On Thu, May 23, 2013 at 03:58:55PM -0400, Christopher Nelson wrote:

...

sql>select * from sys.functions where name = 'text'; +------+------+---------------------------------------------------+------+-------+------+-------+------+ | id | name | func | mod | sql | type | side_ | sche | : : : : : : : effec : ma_i : : : : : : : : t : d : +======+======+===================================================+==== ==+=======+======+=======+======+ | 5246 | text | create function "text" (p inet) returns clob | inet | true | 1 | false | 2000 | : : : external name inet."text"; : : : : : : +------+------+---------------------------------------------------+------+-------+------+-------+------+ 1 tuple (18.424ms)

Are you using a different schema (or default schema)? If so add inet. infront of the "text". That should resolve the function. Niels

...

On Thu, May 23, 2013 at 2:55 PM, Niels Nes wrote:

On Thu, May 23, 2013 at 02:45:27PM -0400, Christopher Nelson wrote: > cnelson@hpvm:/store/meps/db $ mclient -v > mclient, the MonetDB interactive terminal (Feb2013-SP2) > support for command-line editing compiled-in > character encoding: UTF-8 > > cnelson@hpvm:/store/meps/db $ sudo monetdb version > MonetDB Database Server Toolkit v1.1 (Feb2013-SP2)

Could you do a

sql>select * from functions where name = 'text';

Should result in the following

+------+------+---------------------------+------+-------+------+-------+------+ | id | name | func | mod | sql | type | side_ | sche | : : : : : : : effec : ma_i : : : : : : : : t : d : +======+======+===========================+======+=======+======+== =====+======+ | 5246 | text | create function "text" (p | inet | true | 1 | false | 2000 | : : : inet) returns clob : : : : : : : : : external name inet."text : : : : : : : : : "; : : : : : : +------+------+---------------------------+------+-------+------+-------+------+ 1 tuple (3.183ms) sql>

Niels

> > > > On Thu, May 23, 2013 at 2:41 PM, Niels Nes wrote: > > On Thu, May 23, 2013 at 02:35:59PM -0400, Christopher Nelson wrote: > > sql>SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT > NULL > > ORDER BY src, ts LIMIT 5; > > SELECT: no such unary operator 'text(inet)' > > The text function should be part of the 14_inet.sql file which is > loaded the first time you start (the first) client. Which version > are you running? > > Niels > > > > > > > > On Thu, May 23, 2013 at 2:33 PM, Niels Nes < Niels.Nes@cwi.nl> > wrote: > > > > On Thu, May 23, 2013 at 09:35:01AM -0400, Christopher Nelson > wrote: > > > Hi, > > > > > > I noticed in the manual that there are many useful > functions for > > the > > > inet and url types. For example, I would like to convert an > inet > > column > > > to text for use in a Python script (since the > python-monetdb > > module > > > does not support the inet type.) > > > > > > I tried: > > > > > > sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS > NOT NULL > > ORDER > > > BY src, ts LIMIT 5;syntax error, unexpected '(', expecting > SCOLON > > in: > > > "select wlid, text(" > > > > Text is a monetdb sql keyword, ie simply double quote text. > > > > ie > > > > SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT > NULL > > ORDER > > BY src, ts LIMIT 5; > > > > Niels > > > > > > sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src > IS NOT > > NULL > > > ORDER BY src, ts LIMIT 5; > > > unexpected symbol (:) > > > > > > sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src > IS NOT > > NULL > > > ORDER BY src, ts LIMIT 5; > > > syntax error, unexpected '(', expecting SCOLON in: "select > wlid, > > > inet.text(" > > > > > > I have read through the manual sections on types and > functions > > several > > > times now, and I cannot see how to use the specified > functions on > > these > > > types. Any help would be greatly appreciated. > > > > > > Thanks! > > > > > > -={C}=- > > > > > > > > > > > _______________________________________________ > > > users-list mailing list > > > users-list@monetdb.org > > > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl > > url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl > > > > _______________________________________________ > > users-list mailing list > > users-list@monetdb.org > > http://mail.monetdb.org/mailman/listinfo/users-list > > > > > > > > > _______________________________________________ > > users-list mailing list > > users-list@monetdb.org > > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl > url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl > > _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-list > > >

> _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

...

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

Christopher Nelson

8:56 p.m.

I was following the instructions on the "getting started" page, so yes, I created a new schema. I will try that, thanks! On Thu, May 23, 2013 at 4:51 PM, Niels Nes wrote:

...

On Thu, May 23, 2013 at 03:58:55PM -0400, Christopher Nelson wrote:

...
sql>select * from sys.functions where name = 'text';

+------+------+---------------------------------------------------+------+-------+------+-------+------+

...
| id | name | func | mod | sql | type | side_ | sche | : : : : : : : effec : ma_i : : : : : : : : t : d : +======+======+===================================================+==== ==+=======+======+=======+======+ | 5246 | text | create function "text" (p inet) returns clob | inet | true | 1 | false | 2000 | : : : external name inet."text"; : : : : : :

+------+------+---------------------------------------------------+------+-------+------+-------+------+

...
1 tuple (18.424ms)

Are you using a different schema (or default schema)? If so add inet. infront of the "text". That should resolve the function.

Niels

...
On Thu, May 23, 2013 at 2:55 PM, Niels Nes wrote:

On Thu, May 23, 2013 at 02:45:27PM -0400, Christopher Nelson wrote: > cnelson@hpvm:/store/meps/db $ mclient -v > mclient, the MonetDB interactive terminal (Feb2013-SP2) > support for command-line editing compiled-in > character encoding: UTF-8 > > cnelson@hpvm:/store/meps/db $ sudo monetdb version > MonetDB Database Server Toolkit v1.1 (Feb2013-SP2)

Could you do a

sql>select * from functions where name = 'text';

Should result in the following

+------+------+---------------------------+------+-------+------+-------+------+

...
| id | name | func | mod | sql | type | side_ | sche | : : : : : : : effec : ma_i : : : : : : : : t : d : +======+======+===========================+======+=======+======+== =====+======+ | 5246 | text | create function "text" (p | inet | true | 1 | false | 2000 | : : : inet) returns clob : : : : : : : : : external name inet."text : : : : : : : : : "; : : : : : :

+------+------+---------------------------+------+-------+------+-------+------+

...
1 tuple (3.183ms) sql>

Niels

> > > > On Thu, May 23, 2013 at 2:41 PM, Niels Nes wrote: > > On Thu, May 23, 2013 at 02:35:59PM -0400, Christopher Nelson wrote: > > sql>SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT > NULL > > ORDER BY src, ts LIMIT 5; > > SELECT: no such unary operator 'text(inet)' > > The text function should be part of the 14_inet.sql file which is > loaded the first time you start (the first) client. Which version > are you running? > > Niels > > > > > > > > On Thu, May 23, 2013 at 2:33 PM, Niels Nes < Niels.Nes@cwi.nl> > wrote: > > > > On Thu, May 23, 2013 at 09:35:01AM -0400, Christopher Nelson > wrote: > > > Hi, > > > > > > I noticed in the manual that there are many useful > functions for > > the > > > inet and url types. For example, I would like to convert an > inet > > column > > > to text for use in a Python script (since the > python-monetdb > > module > > > does not support the inet type.) > > > > > > I tried: > > > > > > sql>SELECT wlid, text(src), ts FROM web_log WHERE src IS > NOT NULL > > ORDER > > > BY src, ts LIMIT 5;syntax error, unexpected '(', expecting > SCOLON > > in: > > > "select wlid, text(" > > > > Text is a monetdb sql keyword, ie simply double quote text. > > > > ie > > > > SELECT wlid, "text"(src), ts FROM web_log WHERE src IS NOT > NULL > > ORDER > > BY src, ts LIMIT 5; > > > > Niels > > > > > > sql>SELECT wlid, inet:text(src), ts FROM web_log WHERE src > IS NOT > > NULL > > > ORDER BY src, ts LIMIT 5; > > > unexpected symbol (:) > > > > > > sql>SELECT wlid, inet.text(src), ts FROM web_log WHERE src > IS NOT > > NULL > > > ORDER BY src, ts LIMIT 5; > > > syntax error, unexpected '(', expecting SCOLON in: "select > wlid, > > > inet.text(" > > > > > > I have read through the manual sections on types and > functions > > several > > > times now, and I cannot see how to use the specified > functions on > > these > > > types. Any help would be greatly appreciated. > > > > > > Thanks! > > > > > > -={C}=- > > > > > > > > > > > _______________________________________________ > > > users-list mailing list > > > users-list@monetdb.org > > > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl > > url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl > > > > _______________________________________________ > > users-list mailing list > > users-list@monetdb.org > > http://mail.monetdb.org/mailman/listinfo/users-list > > > > > > > > > _______________________________________________ > > users-list mailing list > > users-list@monetdb.org > > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl > url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl > > _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-list > > >

> _______________________________________________ > users-list mailing list > users-list@monetdb.org > http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

...
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-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@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

4236

Age (days ago)

4236

Last active (days ago)

List overview

Download

8 comments

2 participants

participants (2)

Christopher Nelson
Niels Nes

Fwd: Using the inet and url type functions

tags

participants (2)