September 2008 - users-list

[MonetDB-users] Ubuntu packages and launchpad PPA for MonetDB
by Gijs Molenaar 12 Sep '08

12 Sep '08

Hello everyone, I'm working on precompiled Ubuntu packages for MonetDB, which can be found here: https://launchpad.net/~monetdb/+archive These packages are meant for Ubuntu users who don't want to compile monetdb on every Ubuntu system where they want to use this software. You can install the packages and automatically update to new released packages by adding the following to /etc/apt/sources.list: --- 8< cut here --- deb http://ppa.launchpad.net/monetdb/ubuntu hardy main deb-src http://ppa.launchpad.net/monetdb/ubuntu hardy main ------------------- These packages are quite 'fresh' and not fully tested and completed, but the basics should work fine. If you want to test them out or/and you have some comments, feel free to contact me. Note that these packages are not signed due to a limitation in launchpad. -- Gijs Molenaar http://gijs.pythonic.nl

3 5

Re: [MonetDB-users] I'm looking for a fast way to write data to the DB from a scripting language.
by Michalis Polakis 07 Sep '08

07 Sep '08

Good morning Jay, you can use the Ruby MAPI Wrapper => MAPI calls through Ruby. It's elegant and simple and was used to implement the Ruby on Rails adapter for MonetDB. Plus, from what I see in the SWIG input file, the insert and copy_from functions should be implemented in the Ruby MAPI Wrapper. If you want to go the Ruby way, you may find the files in the MonetDB clients package or at http://rubyforge.org/projects/monetdb-ror/ as part of the Ruby on Rails MonetDB adapter. Regards, Michalis ----------------------------------------------------------------------------------------------- Hi, I have 50 million rows and 15 columns that I'd like to put into one table. My first attempt to transfer them was through PHP using the monetdb_query method. This is causing a lot of disk thrashing and my throughput is about 100 rows/sec. I get an "undefined function" error for both monetdb_insert and monetdb_copy_from. I would like to find a fast method, but from inside a common scripting language. Thanks, Jay

3 3

[MonetDB-users] I'm looking for a fast way to write data to the DB from a scripting language.
by JJ Jakosky 07 Sep '08

07 Sep '08

Hi, I have 50 million rows and 15 columns that I'd like to put into one table. My first attempt to transfer them was through PHP using the monetdb_query method. This is causing a lot of disk thrashing and my throughput is about 100 rows/sec. I get an "undefined function" error for both monetdb_insert and monetdb_copy_from. I would like to find a fast method, but from inside a common scripting language. Thanks, Jay

1 0

[MonetDB-users] Dual instances of MonetDB for 1 dbfarm - is it possible?
by McKennirey.Matthew 04 Sep '08

04 Sep '08

3 4

[MonetDB-users] Monetdb - User defined functions
by Kirk Abbott 04 Sep '08

04 Sep '08

Hello, We are trying to move some data over to Monetdb and are finding that we are missing some of our favorite formatting functions (to_date, to_char etc.). Does Monetdb have a user defined functions extension framework? If so, we would try to mimic these functions there. Thanks, Kirk.

3 8

Re: [MonetDB-users] ERROR 404 /~monet/tars/latest/stable/MonetDB.tar.gz.md5sum
by McKennirey.Matthew 04 Sep '08

04 Sep '08

3 2

[MonetDB-users] Incorrect SQL update result
by Christophe Galerne 03 Sep '08

03 Sep '08

Hi, I am running: # MonetDB server v5.6.0, based on kernel v1.24.0 # Serving database 'clg' # Compiled for i686-pc-win32/32bit with 32bit OIDs dynamically linked # Copyright (c) 1993-2008 CWI, all rights reserved # Visit http://monetdb.cwi.nl/ for further information # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.24.0 loaded I am copying some sample SQL which illustrates what I believe is a bug: ################################################################################ CREATE TABLE SOURCE ( TOTO VARCHAR(5), TITI VARCHAR(5), VALUE DOUBLE ); INSERT INTO SOURCE VALUES('1', '1', 5.0) , ('1', '2', 4.0), ('2', '1', 5.0), ('2', '2', 5.0), ('2', '3', 5.0); INSERT INTO SOURCE VALUES('1', '1', 5.0) , ('1', '2', 4.0), ('2', '1', 5.0), ('2', '2', 5.0), ('2', '3', 5.0); CREATE TABLE TARGET ( TOTO VARCHAR(5), TITI VARCHAR(5), VALUE DOUBLE ); INSERT INTO TARGET VALUES('1', '1', 0) , ('1', '2', 0), ('2', '1', 0), ('2', '2', 0), ('2', '3', 0); UPDATE TARGET SET VALUE = ( SELECT SUM(VALUE) FROM SOURCE WHERE TOTO=SOURCE.TOTO and TITI=SOURCE.TITI); CREATE TABLE TARGETOS ( TATA VARCHAR(5), TUTU VARCHAR(5), VALUE DOUBLE ); INSERT INTO TARGETOS VALUES('1', '1', 0) , ('1', '2', 0), ('2', '1', 0), ('2', '2', 0), ('2', '3', 0); UPDATE TARGETOS SET VALUE = ( SELECT SUM(VALUE) FROM SOURCE WHERE SOURCE.TOTO=TATA and SOURCE.TITI=TUTU); ################################################################################ The expected results is for the tables TARGET and TARGETOS to contain the same result since they only differ by the name of their columns. It seems that monetdb gets confused by the fact that table SOURCE and table TARGET have the column names. Thanks, Christophe

2 2

[MonetDB-users] SyntaxException in "monetdb create demo" statement
by rmaadil 03 Sep '08

03 Sep '08

I have installed MnetDB by downloading the file "MonetDB-ODBC-Installer-i386-20080812.msi". Then I opened MonetDB SQL Server. The last message that I got on the command prompt was "MonetDB/SQL module v2.24.0 loaded". Then I tried the statement "monetdb create demo", but I got the following error SyntaxException:parseError:monetdb create demo SyntaxException:parseError ^';' expected Can anybody tell me that where I was going wrong. -- View this message in context: http://www.nabble.com/SyntaxException-in-%22monetdb-create-demo%22-statemen… Sent from the monetdb-users mailing list archive at Nabble.com.

2 5

[MonetDB-users] ERROR 404 /~monet/tars/latest/stable/MonetDB.tar.gz.md5sum
by McKennirey.Matthew 03 Sep '08

03 Sep '08

2 1

Re: [MonetDB-users] [ADT] bug report?
by Stefan Manegold 02 Sep '08

02 Sep '08

On Mon, Sep 01, 2008 at 11:22:10PM +0200, Ying Zhang wrote: > Hi, > > I have just updated my monet source from souceforge and did a from > scratch compilation on my leopard. > > Fabian's fix gets rid of the error "implicit declaration of..." (thanks!) > However, the other error "ISO C90 forbids.." is still there. With the > following patch, I was able to compile the module MonetDB (a complete > rebuild of monet modules is still ongoing). > > I simply moved the definition of len to the begin of the function: > > $ cvs diff src/gdk/gdk_system.mx > Index: src/gdk/gdk_system.mx > =================================================================== > RCS file: /cvsroot/monetdb/MonetDB/src/gdk/gdk_system.mx,v > retrieving revision 1.115 > diff -r1.115 gdk_system.mx > 570a571,574 > > #if defined(__FreeBSD__) || defined(__NetBSD__) || > defined(__OpenBSD__) || defined(__MACH__) > > size_t len = sizeof(int); > > #endif > > > 578d581 > < size_t len = sizeof(int); Thanks. I just checked in (my version of ;-)) your patch. Stefan > Jennie > > > On Sep 01, 2008, at 22:35 , Hendrike Peetz wrote: > >> nope. still the same problem. I checked out from the svn right after I >> got your mail. >> >> On Sep 1, 2008, at 10:13 PM, Fabian Groffen (Project Account) wrote: >> >>> I tried to fix the issue. Please report if it works. >>> >>> On 01-09-2008 22:01:01 +0200, Fabian Groffen (Project Account) wrote: >>>> On 01-09-2008 21:57:13 +0200, Fabian Groffen wrote: >>>>>>> cc1: warnings being treated as errors >>>>>>> ../../../MonetDB/src/gdk/gdk_system.mx: In function >>>>>>> 'MT_check_nr_cores': >>>>>>> ../../../MonetDB/src/gdk/gdk_system.mx:575: warning: ISO C90 >>>>>>> forbids mixed declarations and code >>>>>>> ../../../MonetDB/src/gdk/gdk_system.mx:576: error: implicit >>>>>>> declaration of function 'sysctlbyname' >>>>> >>>>> No. The MonetDB sources aren't tested on Leopard on a daily >>>>> basis, and >>>>> this change/code in particular isn't at all. I tried it on >>>>> Tiger, but >>>>> didn't care to check on Leopard. >>>> >>>> Actually, the actual code was never tested, as it's just missing an >>>> include ;) >> > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0