- users-list - monetdb.org

[MonetDB-users] newbie question about monetdb5 server installation
by Min Zhou 16 Mar '10

16 Mar '10

hi all, I failed in install moentdb beacause the configure script can't find the correct openssl path. here is my instruction ./monetdb-install.sh --prefix=$HOME/monetdb --enable-sql the failure hapened when compiling monetdb5 server with informations like below: configure: error: MonetDB 5 requires OpenSSL (you need a more recent version of OpenSSL) configuring MonetDB5-server failed Please refer to the full log at /var/tmp/MonetDB-1268650686/log If you believe this is an error in the script … [View More]

4 8

[MonetDB-users] Cursor Alternative
by Nafees Ur Rehman 16 Mar '10

16 Mar '10

Hi, Its mentioned on your website (http://monetdb.cwi.nl/SQL/Documentation/SQL-Features.html#SQL-Features) that monetDB/SQL does not support cursors. My question is whether it has any alternative for cursors? I am working on integrating Data Mining techniques with Database systems. So I need to translate the DM algorithms and write them in monetDB. Regards Nafees Ur Rehman University of Konstanz.

2 1

[MonetDB-users] (no subject)
by Abernethy, Simon 15 Mar '10

15 Mar '10

Dear Sir I have been testing the lastest version of mserver5 under Linux on an embedded arm platform (Marvell PXA270 XScale 600Mhz) and a PC. MonetDB server v5.16.5 kernel v1.34 I have built it for gumstix (arm based platform) and for PC I have built it using the monetdb-install.sh with the following parameters export EXTRA_ECONF="-enable-optimize -disable-debug -enable-strict -with-gcc=arm-angstrom-linux-gnueabi-gcc -host=arm-angstrom-linux-gnueabi -with-openssl=$HOME/gumstix/openssl -… [View More]

1 0

[MonetDB-users] merovingian module loading
by Mitja Kleider 09 Mar '10

09 Mar '10

Hello, I would like to use merovingian and load the geom module as if I would be running > mserver5 --dbinit="include geom;include sql;sql.start();" Is this possible with merovingian? Regards Mitja

2 1

[MonetDB-users] sql query size
by dariuszs 06 Mar '10

06 Mar '10

Hi, Is there any limit on how big the sql query can be (in bytes)? Thanks. Dariusz.

3 3

[MonetDB-users] fetch_field errors.
by Guillaume Yziquel 04 Mar '10

04 Mar '10

Hello. I've been reading, in Mapi.mx, the following: > @item char **mapi_fetch_field_array(MapiHdl hdl) > > Return an array of string pointers to the individual fields. A zero > is returned upon encountering end of sequence or error. This can be > analyzed in using @code{mapi\_error()}. As I'm not a big fan of dynamic type checks, or dynamic error checks, I'd appreciate knowing: what kind of errors might this be? Any errors assuming anything might fail? Just to know... --… [View More]

2 3

[MonetDB-users] Cannot load libMapi with C++ after compiling and linking
by Alexander Koglin 03 Mar '10

03 Mar '10

Hi everybody, I tried to setup an Eclipse project by linking the libMapi against it and adding some entities to MonetDB SQL and always get the following error: *.../Project/Debug/Project: error while loading shared libraries: libMapi.so.1: cannot open shared object file: No such file or directory* After all linking and compiling goes alright. When Invoking the GCC C++ Compiler I call the following directive: *g++ -I/usr/local/Tarari/include -I/root/MonetDB/include/MonetDB -I/root/xerces-2.… [View More]

3 2

[MonetDB-users] Cursor Alternative?
by Nafees Ur Rehman 03 Mar '10

03 Mar '10

Hi, Is there any alternative available in MonetDB to operate on records from within the function code? As cursors are not supported. Regards Nafees Ur Rehman Database & Information System Deptt of Computer Science University of Konstanz, Germany.

2 2

[MonetDB-users] Name of fields in query result?
by Guillaume Yziquel 02 Mar '10

02 Mar '10

Hello. Here are a few functions/methods from the postgresql-ocaml binding. > class type result = object > (** Main routines *) > > method nfields : int > (** [#nfields] @return the number of fields in a query result. *) > > method fname : int -> string > (** [#fname n] @return the name of the [n]th field. > > @raise Error if field out of range. > *) > > method fnumber : string -> int > (** [#fnumber field] @return the … [View More]

4 8

[MonetDB-users] Announcement: New Feb2010 feature release of MonetDB suite
by Sjoerd Mullender 02 Mar '10

02 Mar '10

The MonetDB team at CWI/MonetDB BV is pleased to announce the Feb2010 feature release of the MonetDB suite of programs. More information (including release notes) on this release is available at <http://monetdb.cwi.nl/Development/Releases/Feb2010/>. -- Sjoerd Mullender

2 1

[MonetDB-users] Slowdowns after Delete
by Reeves, Matthew J. 01 Mar '10

01 Mar '10

Hello, I have a MonetDB database that contains a table of rolling events. There are 200 million records with 500,000 bulk loaded each day with the oldest 500,000 deleted at midnight. I'm finding the database gets slower as time goes on. It gets to the point of being almost unusable after a week. Is there something I should be doing different? Thanks, Matt

4 4

[MonetDB-users] Xquery Standoff Annotation Success Stories? GATE too?
by David Epstein 25 Feb '10

25 Feb '10

Hello, I am looking for information and experiences with monetdb's standoff annotation extension for Xquery. In particular, I'm looking for a way to more flexibly and conveniently search through documents I've manually annotated for semantic content using GATE (General Architecture for Text Engineering), which has its own standoff format. Has anyone had success in querying GATE documents using monetdb xquery with the standoff extension? If not GATE, what are people using to produce the … [View More]

2 5

[MonetDB-users] path to XML collection using doc() ?
by David Epstein 25 Feb '10

25 Feb '10

Hi everyone, Using the GUI (on localhost) I loaded: Migdal_2001_State_in_Society_BOOK.xml into test_collection_01. Using the query below (from http://monetdb.cwi.nl/XQuery/QuickTour/Books/index.html) as a template but using my own setup and schema, I keep getting: ERROR = !ERROR: err:FODC0002, Error retrieving resource (no such document... I've tried just about every permutation in the doc() statement I can think of. What should the path be? <bib> { for $b in doc("http://… [View More]

2 1

[MonetDB-users] Error on Queries 4.x of Star Schema Benchmark
by Rui Anastácio 23 Feb '10

23 Feb '10

Hello, I'm testing MonetDB with Star Schema Benchmark on a Linux Ubuntu box. I'm able to run all queries except 4.1, 4.2 and 4.3 I've tested with Scale Factor of 1, 5 and 10, and with 1, 3 and 7Gb RAM, and in all situations I gets this error: java.sql.SQLException: MALException:algebra.join:GDK reported error. ERROR: HEAPextend: failed to extend to 954941288 for 15/1560tail at nl.cwi.monetdb.jdbc.MonetConnection$ResponseList.executeQuery(MonetConnection.java:2208) at nl.cwi.… [View More]

3 7

[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

[MonetDB-users] Ubuntu distribution is broken with latest release.
by Mike Mansell 08 Feb '10

08 Feb '10

Attempting to install latest release using Ubuntu packages but the package definition appears to still be referencing the older 1.34.2-20091210 versions while the actual libraries have been updated to the newer 1.34.4-20100112 version. Installation gets errors: W: Failed to fetch http://monetdb.cwi.nl/downloads/Ubuntu/pool/monetdb/m/monetdb/libmonetdb1_1… 404 Not Found W: Failed to fetch http://monetdb.cwi.nl/downloads/Ubuntu/pool/monetdb/m/monetdb-client/libmon… 404 Not Found W: … [View More]

7 14