December 2009 - users-list

Re: [MonetDB-users] MonetDB scalability
by OG 22 Dec '09

22 Dec '09

Hello, Somebody on this list asked about scalability the other day: http://markmail.org/message/2unmuwq2cfz7mrmm I was wondering the same thing. Is there a way to partition/shard MonetDB and still have joins work across partitions living on separate servers? If not, is there a recommended practice for what to do with MonetDB once the limit of a single server has been reached? Thanks, Otis -- Sematext -- http://sematext.com/ -- Solr - Lucene - Nutch

2 1

[MonetDB-users] UTF-8 for table/column names
by Alex Bo. 22 Dec '09

22 Dec '09

Hi, Is there support for UTF8/Unicode for field/table names? It seems like i can only use ASCII characters (for example, a field name with specific Spanish letters wouldn't work) inside field/table names. I'm using the Nov09 on Windows. Thanks. -- View this message in context: http://old.nabble.com/UTF-8-for-table-column-names-tp26888868p26888868.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 3

[MonetDB-users] monetsql except
by Lazaros Koromilas 18 Dec '09

18 Dec '09

i get a weird behavior on sql except. i'm have attached the except.* files from: cat except.sql | mclient -lsql > except.txt notice the tuple: [ 425, 719, "people", "person", NULL ] is returned in all 3 queries; shouldn't except prevent this? any help? i'm runnig on: MonetDB server v5.6.0 (32-bit), based on kernel v1.24.0 (32-bit oids) Copyright (c) 1993-2008 CWI, all rights reserved Visit http://monetdb.cwi.nl/ for further information Configured for prefix: /usr/local Libraries: libpcre: 7.9 2009-04-11 (compiled with 7.9) openssl: OpenSSL 0.9.8k 25 Mar 2009 (compiled with OpenSSL 0.9.8k 25 Mar 2009) Compiled by: root@redrawn Compilation: gcc -O2 -std=c99 Linking : /usr/bin/ld thanx, lazaros. -- http://www.ics.forth.gr/~koromil

3 4

[MonetDB-users] Announcement: New Nov2009-SP1 bugfix release of MonetDB suite
by Sjoerd Mullender 18 Dec '09

18 Dec '09

The MonetDB team at CWI/MonetDB BV is pleased to announce the Nov2009-SP1 bug fix release of the MonetDB suite of programs. More information on this release will be available at <http://monetdb.cwi.nl/Development/Releases/Nov2009/>. Fixes include: - The Windows installers for MonetDB/SQL in the Nov2009 release were incomplete. The missing files have been added. - Fixed performance issue with loading complex schemas in readonly mode in MonetDB/SQL. - Fixed performance issue with grouping in MonetDB/SQL when one of the columns is sorted. - Fixed problems with LIKE joins in MonetDB/SQL. - Load all files in a multi-file COPY INTO query. - Fix error reporting of unexpected input in XQuery queries to be Unicode aware. - Correctly handle circular dependencies in FD property check. (SF bug #2908615.) - Fixes throughout the code base to better cope with unexpected situations (such as memory shortage). -- Sjoerd Mullender

1 0

[MonetDB-users] ODBC Driver
by Nafees Ur Rehman 17 Dec '09

17 Dec '09

Hi, thanks for helping me in enabling history. I want to connect monetDB with Microsoft SQLServer DM tool. I tried to register ODBC driver for monetDB and followed the instructions but no luck. I would appreciate if you can guide me on that. Please note I am running win xp. Regards Nafees Ur Rehman

2 1

[MonetDB-users] commercial support
by Alfred Nordman 16 Dec '09

16 Dec '09

Hi, The home page of Monetdb implies that there is a commercial support. Is there a contact person or email address which I can use in order to learn about this service? Thanks. Alfred. -- View this message in context: http://old.nabble.com/commercial-support-tp26814876p26814876.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] MonetDB & memory issues on Windows
by Alex Bo. 16 Dec '09

16 Dec '09

Hi, I have been using MonetDB on windows for a while now, and I have consistent problems with all versions up to Nov2009 with memory handling. I don't know if it's because I'm running on Windows, or because I'm doing something wrong, or maybe the problem is in MonetDB, but I cannot work with Monet for long periods of time without routinely restarting the server to free up memory. It seems that over time, MonetDBs memory consumption goes up and up, and eventually when running a heavy query when there's not much memory left, the server crashes. If, however, I restart the server once in a while, all memory is freed, and I can work for longer periods without any problems. So it seems that Monet on Windows has a problem in freeing resources. Some recources are only cleaned on stopping the server. This is true both for COPY INTO operations and for querying. I would appreciate it if you could point out to me how I should approach this. Is this a problem in Monet? Is this because I'm running on Windows? If so, which files can I look into in order to look for problems? -- View this message in context: http://old.nabble.com/MonetDB---memory-issues-on-Windows-tp26808719p2680871… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Remote connections & "merovingian"
by Venks 15 Dec '09

15 Dec '09

Can I connect remotely via JDBC using "merovingian"? In short, how will i set mapi_open = true using "merovingian"? -Venks

2 2

[MonetDB-users] Bulk load problem
by Raghav Kumar Gautam 14 Dec '09

14 Dec '09

Hi, I am a new user and I am trying to bulk load a very largefile. The following is intended for testing only: $ 7z e -so data.7z | head -n 100 | query "copy 100 RECORDS into data_table FROM STDIN USING DELIMITERS tuple_seperator '\r\n' record_seperator '\t';" And am getting the following error: MAPI = rk@localhost:50000 QUERY = copy 100 RECORDS into data_table FROM STDIN USING DELIMITERS tuple_seperator '\r\n' record_seperator '\t'; ERROR = !syntax error, unexpected IDENT, expecting STRING in: "copy 100 records into data_table from stdin using delimiters tuple_seperator" Timer 0.278 msec Can you tell me where am I going wrong ? With Regards, Raghav.

5 5

[MonetDB-users] enabling history
by Nafees Ur Rehman 14 Dec '09

14 Dec '09

Hi, I tried set history=true; statement to enable history, but it throws an exception that two functions are missing.I want to load these two functions but I don't have them in any of the directory of monetdb. Please note that I am running monetdb SQL on windows xp. I would highly appreciate your kind help. Regards Nafees Ur Rehman

3 2