February 2009 - users-list

[MonetDB-users] Please, HELP me!
by taoxiaofang 18 Feb '09

18 Feb '09

Hello, my friends： I have just installed the latest version of MonetDB5 (SQL) on windows, 32bit system. When I start the client (start-programs-MonetDB5-MonetDB SQL Client), after I start the server (start-programs-MonetDB5-MonetDB SQL Server), the client window prompted start with sql, and I can not use the command like -d. -f, -H, -u and so on, moreover, I can not specify the user or the schema. If I want to use these commands and to specify the user and the schema, what I should do. Hoping for your reply! Best regards. 2009-02-18 taoxiaofang

1 0

[MonetDB-users] Java 1.6 and MonetDB JDBC driver
by Fabian Groffen 17 Feb '09

17 Feb '09

http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6795561 The MonetDB JDBC driver is affected by above bug, which manifests itself as an IndexOutOfBoundsException thrown somewhere deep from the heart of the driver in the mcl StartOfHeaderParser. The only workaround is to use JDK 1.4 or 1.5 if you hit this problem.

2 1

[MonetDB-users] sql - division
by dariuszs 13 Feb '09

13 Feb '09

Hello, How do I modify this sql to get correct answer? sql> select 10/100; I got 0 instead of 0.10 Thanks. Dariusz.

2 2

[MonetDB-users] Challenge string is not valid
by David Svenson 12 Feb '09

12 Feb '09

Hi, While working with MonetDB, I suddenly reached some sort of state in which I constantly get: "Challenge string is not valid" Whenever I try to connect to MonetDB. I am using the Mapi libraries, and get the same error if I use mclient.exe. I can't figure out how I reached this state and how I'm supposed to get out of it. Please help. Thanks, David. -- View this message in context: http://www.nabble.com/Challenge-string-is-not-valid-tp21976173p21976173.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] copy/select * from /into - very slow
by dariuszs 09 Feb '09

09 Feb '09

Hi, Could you please help me here. I've got 300 fields, 100 million records, 800 bytes per row in a table. Exporting 60 fields into a table takes about 1 minute and selecting * from table takes very long time, and I don't see lots of cpu usage when exporting all records. Thanks. Dariusz.

2 9

[MonetDB-users] Algebra Mode vs sql debug 16384
by Ross Bates 06 Feb '09

06 Feb '09

Hi All - can someone help me clarify the difference between Algebra "-G" mode and setting SQL debug equal to 16384 in the monetdb config file? With an older version of MonetDb I set the sql_debug=16384 in the config file so I could take advantage of Algebra mode when starting the server via mero. Today I compiled the Nov08-SP2 release and ran some tests using sql_debug=0 vs sql_debug=16384. I assumed they would do the exact same since Algebra mode is now the default. They returned very different results however. For SQL statements with a large number of predicates (100+), performance is about the same. But for anything smaller the query speed is much worse (10x avg) when I don't have sql_debug=16384 turned on. The query trace files are also different when I run the exact same query with and without the 16384 flag. I made sure to restart the server process in between. Also, below is the latest output from mserver --version: Copyright (c) 1993-July 2008 CWI Copyright (c) August 2008- MonetDB B.V., all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: /home/ross/monetNov08sp2 Libraries: openssl: OpenSSL 0.9.8g 19 Oct 2007 (compiled with OpenSSL 0.9.8g 19 Oct 2007) Compiled by: ross@home Compilation: gcc -O2 -std=c99 -fgnu89-inline -O6 -fomit-frame-pointer -finline-functions -falign-loops=4 -falign-jumps=4 -falign-functions=4 -fexpensive-optimizations -funroll-loops -frerun-cse-after-loop -frerun-loop-opt -ftree-vectorize Linking : /usr/bin/ld Any thoughts? Best Regards, Ross

5 4

[MonetDB-users] sql - string functions
by dariuszs 06 Feb '09

06 Feb '09

Hi, Just wondering why - strings functions seem to be very slow eg. 'select substring(field1,1,10) || substring(field2,1,20) as field3 from table1'. Thanks for help. Dariusz.

1 0

[MonetDB-users] Fedora 9 RPMs in Stable DailyBuild directory
by Hans van Rijswijk (DT) 06 Feb '09

06 Feb '09

Dear MonetDB users, In the release directories (http://monetdb.cwi.nl/downloads/Fedora/9/x86_64/) I can find RPMs for Fedora 9. Why can't I find Fedora 9 RPMs in the Stable DailyBuild directory (http://monetdb.cwi.nl/testing/projects/monetdb/Stable/.DailyBuilds./200 90206/RPMs/) ? I needs to make a distribution including the latest Stable MonetDB and including Fedora 9 RPMs. Regards, Hans van Rijswijk

2 1

[MonetDB-users] Re naming a column via MAL/SQL
by Alfred Nordman 03 Feb '09

03 Feb '09

Hi guys, Is there a way to rename an existing column within a table via SQL? (the RENAME COLUMN syntax is not supported as it seems) and if not, can i do it via MAL? I tried to use MAL as follows, but after i do, the DB seems to get corrupt when i try to access the specific table. include sql; sql.init(); bat1 := sql.bind("sys","t1","Field1",0); bat.setName(bat1,"Field2"); bat.setPersistent(bat1,true); bot.commit; Thanks & Best Regards... -- View this message in context: http://www.nabble.com/Renaming-a-column-via-MAL-SQL-tp21807788p21807788.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Logs & Corrupt databases
by David Svenson 02 Feb '09

02 Feb '09

Hi, Every once in a while I get this message in the server: !ERROR: Please move away <log folder> and its corresponding dbfarm. !mvc_init: unable to create system tables When I delete the logs from the log folder, the server starts normally and the database is ok. Any ideas on what the reason for that might be? Is it possible to disable logging altogether? Thanks, David. -- View this message in context: http://www.nabble.com/Logs---Corrupt-databases-tp21792046p21792046.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0