February 2010 - users-list

[MonetDB-users] Different query results after each execution
by Alex Bo. 20 Feb '10

20 Feb '10

Hi, I am getting weird behavior with a query that involves a LIKE comparison: This is the query: SELECT ("test2"."a1") AS "a1", (Count(DISTINCT CASE WHEN (Lower("test2"."a2") LIKE '%aaa%') THEN "test2"."a3" ELSE NULL END)) AS "m1" FROM "test"."test2" GROUP BY "test2"."a1" Whenever I run this query I get different results in my m1 field. If I remove the LIKE then it … [View More]

1 0

[MonetDB-users] Weird behaviour with namespaces in XQuery
by Ignacio Martín Oya 19 Feb '10

19 Feb '10

Hello: I'm using MonetDB for a project. I've observed some weird results when doing a XQuery on an inserted document. Steps to reproduce the bug are: xquery>pf:add-doc ('file://var/tmp/pres-rules.xml', 'pres-rules.xml', 'pres-rules', 1) more>xquery>declare namespace xs="http://www.w3.org/2001/XMLSchema"; more>declare namespace cr="urn:ietf:params:xml:ns:common-policy"; more>declare namespace pr="urn:ietf:params:xml:ns:pres-rules"; more>count (doc('pres-rules.xml')/cr:… [View More]

1 0

[MonetDB-users] Monetdb + unixODBC
by Alexander Barkov 18 Feb '10

18 Feb '10

Hello, I am a new in MonetDB. I'm testing MonetDB + unixODBC with an application which inserts long BLOB values, and I'm having some problems. Can you please help me? 1. When I use rc= SQLBindParameter(hstmt, position, SQL_PARAM_INPUT, SQL_C_DEFAULT, SQL_LONGVARBINARY, 0, 0, (char*) data, data_size, &BindBuf[position]… [View More]

2 9

[MonetDB-users] MAL BAT Types
by Gerrard_56 14 Feb '10

14 Feb '10

hi, I’m writing a theoretical paper about MonetDB and I have a question about the MAL. Does the MAL also use inverted lists and are the updated in the same way described for the MIL in the thesis of P. A. Boncz “Monet: A Next-Generation DBMS Kernel For Query-Intensive Applications” on page 137f. Thanks for any information gerrard -- View this message in context: http://old.nabble.com/MAL-BAT-Types-tp27583769p27583769.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 1

[MonetDB-users] Admin GUI is blank page
by jasonpriem 12 Feb '10

12 Feb '10

Hi, I've just installed MonetDB on my 32-bit Vista system. The server and client both start up fine; however, http://127.0.0.1:50001/admin gives me a blank page. I can't really think of much to try, save deactivating the firewall (which made no difference). Any suggestions? Thanks. -- View this message in context: http://old.nabble.com/Admin-GUI-is-blank-page-tp27559054p27559054.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] Missing element names when bulkloading XML files into MonetDB
by Alexander Koglin 12 Feb '10

12 Feb '10

I have buldloaded a collection of 10.000 XML files into MonetDB like this: for $d in doc("/monetdbfiles.xml")//doc return pf:add-doc(fn:concat($d/@path,$d/@name), fn:string($d/@name), "abap10k", 0) <> Now the XML files have missing element names and look like this in MonetDB: <AST> < type="compound" line="1" id="1"> < type="stmt" line="1" id="2"/> < type="stmt" line="5" id="3"> < type="clause" line="5" id="4"> < type="idf" line="5" id="5"/> </&… [View More]

2 1

[MonetDB-users] Pager in mclient?
by Mark Bucciarelli 11 Feb '10

11 Feb '10

>From man page, it looks like I should be able to pipe the output of a command through less. But I can't figure out the syntax. For example: sql>\|less \d mytable sql> Can I do this? If so, is there a way to set it up so this always happens? This is candidate release from November 2009. Thanks, Mark

2 1

[MonetDB-users] where is the data?
by Zoltan Tomory 09 Feb '10

09 Feb '10

Curiosity has gotten the best of me. Where is the datafile/s kept and what is it called? Thanks in advance, Zoltan Tomory

2 1

[MonetDB-users] Monetdb and Hardy Heron
by Radek Maciaszek 09 Feb '10

09 Feb '10

Hi, I noticed the release for Karmic Koala but none for Hardy Heron. Is it possible to install monetdb with hardy? Is there perhaps any wiki page in monetdb documentation which expplains steps? Looking forward to trying monetdb! Radek

3 3

[MonetDB-users] dump and restore---use merovingian database files?
by Mark Bucciarelli 09 Feb '10

09 Feb '10

I just had to restore a database dump, and I got nervous watching top. The box, which doesn't have much RAM, started to swap on the restore. At times, the monetdb process was using over 90% of available RAM. While I only have 500M RAM, the database only has 10m records. The gzipped dump is 142MB. Other than the backup/restore issue, Monet seems quite happy running with this much data and so little RAM. It looks like it could support much more data---but I'm not so sure the restore will. … [View More]

3 3