- users-list - monetdb.org

[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... -- Guillaume Yziquel http://yziquel.homelinux.org/

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.8/include -O0 -g3 -Wall -c -fmessage-length=0 `monetdb-clients-config --cflags --libs` -MMD -MP -MF"src/IndexHandler.d" -MT"src/IndexHandler.d" -o"src/IndexHandler.o" "../src/IndexHandler.cpp" g++ -I/usr/local/Tarari/include -I/root/MonetDB/include/MonetDB -I/root/xerces-2.8/include -O0 -g3 -Wall -c -fmessage-length=0 `monetdb-clients-config --cflags --libs` -MMD -MP -MF"src/MonetMapiUpdater.d" -MT"src/MonetMapiUpdater.d" -o"src/MonetMapiUpdater.o" "../src/MonetMapiUpdater.cpp" g++ -I/usr/local/Tarari/include -I/root/MonetDB/include/MonetDB -I/root/xerces-2.8/include -O0 -g3 -Wall -c -fmessage-length=0 `monetdb-clients-config --cflags --libs` -MMD -MP -MF"src/NodeFetcher.d" -MT"src/NodeFetcher.d" -o"src/NodeFetcher.o" "../src/NodeFetcher.cpp"* When invoking the GCC C++ Linker I call the following directive: *g++ -L/usr/local/Tarari/lib -L/root/MonetDB/lib -L/root/xerces-2.8/lib `monetdb-clients-config --cflags --libs` -o"NodeFetcherCPP" ./src/IndexHandler.o ./src/MonetMapiUpdater.o ./src/NodeFetcher.o -lMapi -ltararixpath -lxerces-c * What can be the reason for the error during execution? Thank you for any help, Alexander

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 index of the field named [field]. > > @raise Not_found if no such named field. > *) I'm looking for equivalents of fname and fnumber methods in MAPI. Couldn't find an equivalent. So, is there a way, when you get the result of a query, to get the names of the fields in the result? All the best, -- Guillaume Yziquel http://yziquel.homelinux.org/

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 standoff notation? thank you, -david David Epstein PhD Candidate Urban & Regional Planning University of Michigan USA

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://monetdb.cwi.nl/XQuery/files/bib.xml")/bib/book where $b/publisher = "Addison-Wesley" and $b/@year > 1991 return <book year="{ $b/@year }"> { $b/title } </book> } </bib> thank you, -david

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.monetdb.jdbc.MonetConnection$ResponseList.processQuery(MonetConnection.java:1967) at nl.cwi.monetdb.jdbc.MonetStatement.internalExecute(MonetStatement.java:434) at nl.cwi.monetdb.jdbc.MonetStatement.execute(MonetStatement.java:347) at nl.cwi.monetdb.jdbc.MonetStatement.executeQuery(MonetStatement.java:451) at test.Main.test(Main.java:188) at test.Main.main(Main.java:158) With 1 Gb of RAM it could be lack of memory but not with 7Gb and a SF of 1. Any idea why this occours? Thanks. Rui Anastácio

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 behaves fine. I can't seem to reproduce it on new tables with little data, but with the data I have (a table with 109402 rows) it does reproduce all the time. Can I upload the dbfarm and file this as a bug? -- View this message in context: http://old.nabble.com/Different-query-results-after-each-execution-tp276669… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0