- users-list - monetdb.org

Re: [MonetDB-users] COPY...INTO from remote
by Matthew Jones 10 Sep '09

10 Sep '09

The original suggestion was to use 'mclient' with the '<' redirect operator I'm assuming like this: mclient -lsql -s "COPY INTO table from STDIN DELIMITERS '\t';" < recordsfile but this doesn't work, it wants to interpret the contents of the file as a query... is there no way to batch load from a script from a remote monet instance? 73, Matthew W. Jones (KI4ZIB) http://matburt.net

3 2

[MonetDB-users] monetdb-install.sh: com.sun.tools.javac.Main is not on the classpath.
by Ying Zhang 09 Sep '09

09 Sep '09

Hi all, I logged in on another INS1 desktop 'vili', and try to install monetdb there with $monetdb-install.sh --enable-xquery --enable-optimize --nightly=stable --prefix="/export/scratch0/zhang/MonetDB" and it ends in: BUILD FAILED /var/tmp/MonetDB-1252495100/MonetDB-java/java/build.xml:94: The following error occurred while executing this line: /var/tmp/MonetDB-1252495100/MonetDB-java/java/build.xml:289: Unable to find a javac compiler; com.sun.tools.javac.Main is not on the classpath. Perhaps JAVA_HOME does not point to the JDK. It is currently set to "/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0.x86_64/ jre" While javac says: $ which javac /usr/bin/javac $ javac -version javac 1.6.0_0 Manually setting JAVA_HOME to my own java installation ends in the same error: $env JAVA_HOME=/ufs/zhang/install/java/current monetdb-install.sh -- enable-xquery --enable-optimize --nightly=stable --prefix="/export/ scratch0/zhang/MonetDB" The log is attached. Thanks in advance. Jennie

3 4

[MonetDB-users] Serious concurrency issues via python api
by Matthew Jones 09 Sep '09

09 Sep '09

I have multiple processes reading and writing to the same table and I've noticed really persistent concurrency problems: File "/usr/lib/python2.5/site-packages/monetdb/sql/cursors.py", line 208, in execute self.__store_result(block) File "/usr/lib/python2.5/site-packages/monetdb/sql/cursors.py", line 520, in __store_result self.__exception_handler(InterfaceError, "Unknown state, %s" % block) File "/usr/lib/python2.5/site-packages/monetdb/sql/cursors.py", line 574, in __exception_handler raise exception_class(message) InterfaceError: Unknown state, &2 65541 -1 !ERROR: COMMIT: transaction is aborted because of concurency conflicts, will ROLLBACK instead I'm not sure what the problem is, but it exists in such a way that all operations that load or update information in MonetDB have to be put into a loop to continuously retry. I'm using autocommit, but I would expect MonetDB to handle concurrency issues in a decent way, like maybe blocking a query until the other query finished. I'm not clobbering data, most of these are just bulk load operations that insert new rows. Is there any way to address this issue without having to putting retry loops around all of the code I'm writing to write to the database? 73, Matthew W. Jones (KI4ZIB) http://matburt.net

6 10

[MonetDB-users] readline/readline.h does not contain rl_completion_func_t
by Ying Zhang 08 Sep '09

08 Sep '09

Hello, I was trying to install monet on Mac OS 10.5 with monetdb-install.sh --enable-xquery --enable-optimize --nightly=stable It has always worked, but this time, it stops due to an error while configuring MonetDB: checking readline/readline.h usability... yes checking readline/readline.h presence... yes checking for readline/readline.h... yes checking for readline in -lreadline... yes checking for rl_completion_matches in -lreadline... no checking whether rl_completion_func_t exists... configure: error: readline/readline.h does not contain rl_completion_func_t, is it GNU readline? The complete log is in the attachment. What is wrong with my readline.h? How can I find out which readline.h the install script is checking, and which readline.h is expected / should be used? Thanks in advance. Jennie

2 3

[MonetDB-users] OpenSSL and SHA512
by Alex Bo. 08 Sep '09

08 Sep '09

Hi, I have compiled the latest August build from CVS on windows. When I run mclient, I get this: server requires 'SHA512' hash, but client support was not compiled in I saw another thread regarding this before, but couldn't resolve the issue based on it. Please let me know what I might be doing wrong. Here is my server output: # MonetDB server v5.14.0, based on kernel v1.32.0 # Serving database 'demo', using 1 thread # Compiled for i686-pc-win32/32bit with 32bit OIDs dynamically linked # Copyright (c) 1993-July 2008 CWI. # Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved # Visit http://monetdb.cwi.nl/ for further information #warning: please don't forget to set your vault key! #(see C:\MonetCVS_base_Aug09\MonetCVS32_cleanBuild\Install\etc\monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ > Thanks. -- View this message in context: http://www.nabble.com/OpenSSL-and-SHA512-tp25223356p25223356.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 5

[MonetDB-users] using MonetDB for INEX data
by Erik Tjong Kim Sang 07 Sep '09

07 Sep '09

Dear MonetDB users, We are trying to add load the INEX XML Wikipedia data into MonetDB but we get some strange error messages: When adding documents: $ echo 'pf:add-doc("/data/erikt/inex2009/tmp/330.xml", "330")' | /storage/erikt/MonetDB/bin/mclient -lxquery MAPI = monetdb@localhost:50000 QUERY = pf:add-doc("/data/erikt/inex2009/tmp/330.xml", "330") ERROR = !ERROR: interpret_params: insert(param 3): invalid BAT. When querying the data: $ echo -e 'let $c := collection("330")\nfor $t in $c//article\nreturn($t//title/text())' | /storage/erikt/MonetDB/bin/mclient -lxquery ... text {"The Black Stallion (film)"}, text {"Halle, Germany"}, text {"FLCL"}, write error We get only 5% of the data that was expected from the query and then it crashes with the message "write error". Does anyone know what could cause these problems? Please respond to me personally (e.f.tjong.kim.sang(at)rug.nl) since I am not a member of this mailing list. Erik TKS -------- e-mail: e.f.tjong.kim.sang(a)rug.nl WWW: http://www.let.rug.nl/erikt/

2 2

[MonetDB-users] Segmentation fault
by Sten Hjelmqvist 07 Sep '09

07 Sep '09

Using MonetDB Aug 2009 on a Ubuntu Server 9.04 with 4Gbyte memory and 60Gbyte free disk space. I import a large database, ~1.5Gbyte , using \<filename. After a while the database exits with msg: ">Segmentation fault" Can I reconfigure the database to avoid this? --------------------------------------- Sten Hjelmqvist DataKonsult MERdata AB Sveavägen 33, 111 34 Stockholm Mobil : 0708 305616 E-mejl : sten.hjelmqvist(a)merdata.se <mailto:sten.hjelmqist@merdata.se> Webb : www.merdata.se <http://www.main.se/> ---------------------------------------

3 6

[MonetDB-users] XQUF: expected insert speed
by Ying Zhang 06 Sep '09

06 Sep '09

Hi all, Does anyone have an idea of the 'normal' insert speed (e.g., #nodes per sec, or #MBs per sec) of MonetDB/XQuery? I inserted a document of ~101mb into an xmark document of 2mb, and it took more than 10 minutes: $ mclient -lx -g -t xquery>do insert doc("persons.xml")/persons into doc("xmark2mb.xml")/ site more><> Trans 12.143 msec Shred 8.429 msec Query 5.869 msec Update 619019.583 msec Timer 619058.179 msec With the algebra back-end, it ends in an error (bug report will follow), but it is also not faster: $ mclient -lx -t xquery>do insert doc("persons.xml")/persons into doc("xmark2mb.xml")/ site more><> MAPI = monetdb@localhost:50000 QUERY = do insert doc("persons.xml")/persons into doc("xmark2mb.xml")/ site ERROR = !ERROR: interpret: no matching MIL operator to '-(lng, void)'. !MAYBE YOU MEAN: ! -(dbl) : dbl ! -(lng) : lng ! -(flt) : flt ! -(wrd) : wrd ! -(int) : int ! -(sht) : sht ! -(bte) : bte ! -(chr) : chr ! -(lng, dbl) : dbl ! -(lng, flt) : dbl ! -(lng, lng) : lng ! -(lng, wrd) : lng ! -(lng, int) : lng ! -(lng, sht) : lng ! -(lng, bte) : lng ! -(lng, chr) : lng ! -(dbl, dbl) : dbl ! -(dbl, flt) : dbl ! -(dbl, lng) : dbl ! -(dbl, wrd) : dbl ! -(dbl, int) : dbl ! -(dbl, sht) : dbl ! -(dbl, bte) : dbl ! -(dbl, chr) : dbl ! -(flt, dbl) : dbl ! -(flt, flt) : flt ! -(flt, lng) : flt ! -(flt, wrd) : flt ! -(flt, int) : flt ! -(flt, sht) : flt ! -(flt, bte) : flt ! -(flt, chr) : flt ! -(wrd, dbl) : dbl ! -(wrd, flt) : flt ! -(wrd, lng) : lng ! -(wrd, wrd) : wrd ! -(wrd, int) : wrd ! -(wrd, sht) : wrd ! -(wrd, bte) : wrd ! -(wrd, chr) : wrd ! -(int, dbl) : dbl ! -(int, flt) : flt ! -(int, lng) : lng ! -(int, wrd) : wrd ! -(int, int) : int ! -(int, sht) : int ! -(int, bte) : int ! -(int, chr) : int ! -(sht, dbl) : dbl ! -(sht, flt) : flt ! -(sht, lng) : lng ! -(sht, wrd) : wrd ! -(sht, int) : int ! -(sht, sht) : sht ! -(sht, bte) : sht ! -(sht, chr) : sht ! -(bte, dbl) : dbl ! -(bte, flt) : flt ! -(bte, lng) : lng ! -(bte, wrd) : wrd ! -(bte, int) : int ! -(bte, sht) : sht ! -(bte, chr) : bte ! -(bte, bte) : bte ! -(chr, dbl) : dbl ! -(chr, flt) : flt ! -(chr, lng) : lng ! -(chr, wrd) : wrd ! -(chr, int) : int ! -(chr, sht) : sht ! -(chr, bte) : bte ! -(chr, chr) : chr Timer 632991.583 msec xquery>\q <persons> is the root node of the document 'persons.xml', which contains 234599 xmark <person> nodes. So, actually, only one large node is inserted. It looks quite slow. Is this the expected behaviour or did I do something wrong? I'm using the latest stable version of MonetDB/XQuery, compiled and installed with 'monet-install.sh --enable-xquery --enale-optimize -- nightly=stable --prefix=...'. The document 'xmark2mb.xml' was shredded as an updatable doc. with 10% holes, and the document 'persons.xml' was shredded as a read-only doc. Both documents were already loaded, by executing the query 'count(doc("[docname]")// person)'. MonetDB/XQuery is running on my CWI PC (i.e., FC10, Intel(R) Core(TM)2 Quad CPU Q6600 @2.40GHz, 8GM RAM). During the execution, one CPU is constantly busy for 100%, Mserver uses 22% ~ 27% of MEM (according to 'top'). Does anyone have an idea how to get insert faster? Regards, Jennie

1 0

[MonetDB-users] Long query response time with 'in' statement
by mkurtulus 02 Sep '09

02 Sep '09

Hi, I'm trying to create a benchmark MonetDB vs Postgres and for many types of queries, MonetDB quite faster than Postgres.But there is an interesting result when i try a query which contains an 'in' statement.The response times are MonetDB - 58 sec Postgres - 3 sec for the query : select RFOADV_10.rfoadvsup as c0, sum((case when cabact___rfountide = 'NB_E' then cabactqte else 0 end)) as m0 from RFOADV as RFOADV_10, CABACT as CABACT where (cabact___rforefide = 'FHSJ' and cabact___rteprcide = 'CPTANA' and cabact___rtestdide = '100' and cabact___rfovsnide = '200805_001') and CABACT.cabact_c2rfodstide = RFOADV_10.rfoadvinf and RFOADV_10.rfoadvsup in ('5030', '5031', '5032', '5033', '5034', '5035', '5036', '5037', '5038') group by RFOADV_10.rfoadvsup i reform the query so that it can give the same result without 'in' : select RFOADV_10.rfoadvsup as c0, sum((case when cabact___rfountide = 'NB_E' then cabactqte else 0 end)) as m0 from RFOADV as RFOADV_10 join CABACT on (CABACT.cabact_c2rfodstide = RFOADV_10.rfoadvinf) join (select '5031' as pole UNION select '5032' as pole UNION select '5033' as pole UNION select '5034' as pole UNION select '5035' as pole UNION select '5036' as pole UNION select '5037' as pole UNION select '5038' as pole ) sub ON (RFOADV_10.rfoadvsup = sub.pole) where (cabact___rforefide = 'FHSJ' and cabact___rteprcide = 'CPTANA' and cabact___rtestdide = '100' and cabact___rfovsnide = '200805_001') group by RFOADV_10.rfoadvsup the response time for MonetDB decreases 100 times (0.6 sec). Do you have any idea about it ? I run both Monetdb and Postgres on a server with 10GB Ram and the tables have CABACT : 677000 RFOADV : 140000 rows. Thanks, Mehmet -- Open WebMail Project (http://openwebmail.org)

2 5

[MonetDB-users] COPY...INTO with auto increment
by Matthew Jones 31 Aug '09

31 Aug '09

I noticed that COPY...INTO for bulk loading requires that all fields be present in the data file. Is there any way to use bulk loading and have it honor the auto increment column or at least not have to specify every column in the data file? 73, Matthew W. Jones (KI4ZIB) http://matburt.net

3 9

[MonetDB-users] Function overloading
by Alex Bo. 30 Aug '09

30 Aug '09

Hi, I am trying to create an overloaded iif function, so I created these custom functions: 1. create function iifnew(tv timestamp, fv timestamp, cond boolean) returns timestamp begin if cond then return tv; else return fv; end if; end 2. create function iifnew(tv int, fv int, cond boolean) returns int begin if cond then return tv; else return fv; end if; end 3. create function iifnew(tv string, fv string, cond boolean) returns string begin if cond then return tv; else return fv; end if; end But now, if I do something like this: update table1 set "Column1" = iifnew('hello1', 'hello2', ("Column2" = "Column3")) I get this: !SQLException:int:conversion of string 'hello1' failed Is this a bug in function overloading? I am running Feb2009 from CSV on Windows. Thanks. -- View this message in context: http://www.nabble.com/Function-overloading-tp25210862p25210862.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] tijah phrase search problem
by Roy Walter 27 Aug '09

27 Aug '09

The following query: tijah:queryall("//p[about(., 'drug treatment')]") returns a number of results from my sample document. Some of these results contain the phrase "drug misuse". The following query: tijah:queryall("//p[about(., 'drug misuse')]") returns zero results from the sample document, which is clearly incorrect since some results returned by the first query should be returned by the second. I have deleted and reloaded the sample document and I have recreated the tijah index and the result is consistently incorrect. Is this a bug? -- Roy

2 5

[MonetDB-users] What's the best file system and sector size for monetdb?
by Allen Zhang 26 Aug '09

26 Aug '09

Hi, What is the best suitable file system and sector size for monet dbfarm? Can anyone share the experience? Thanks Allen

1 0

[MonetDB-users] Performance vs postgresql
by jatin patni 24 Aug '09

24 Aug '09

Hi, I am in the process of evaluating two major databases....monetdb and postgresql for building a backend database system for backtesting on huge historical data sets around 100GB. I copied some test data(a 250mb table) using bulk copy in both and monetdb was way faster. But when I did a simple query "SELECT * from tablename", it took around 3 minutes for 1 lakh rows via mclient and a gui interface (aqua studio based on JVM simply said out of memory). The bulk copy file was in the format collumns seperated by pipes in a text file. While using postgresql, at first it was slow but once I did a vacuum(function in postgresql), the (select * from tablename) was much faster than monetdb. So, what am I missing here, Do I need to do something to enhance the performance in Monetdb....... I have high hopes from monetdb, so please help. Thanks -- Jatin Patni Tel: 91 9911 649 657 jatinpatni(a)gmail.com www.jatinpatni.co.nr

3 4

Re: [MonetDB-users] Performance vs postgresql(Stefan Manegold)
by jatin patni 23 Aug '09

23 Aug '09

Hi Stefan, Thanks for your reply. Well, I understand that a simple dump of the table wouldn't be that fast in monetdb cuz it was not built for that purpose. I am evaluating monetdb 5 and postgresql plus standard server from enterprise db. I have not yet tested performance of running complex queries on both systems. I am testing on windows 32 bit, core2duo processor, 2.8 ghz, with 3gb ram 2.8 ghz I hope this config would work fine for backtesting with around 100 gb databases. Will post a detailed result of using both postgresql and monetdb later. Let me go into some detail.....my database would have 4 collumns(sno, price, name, volume) and my backtesting would generally involve querying this dataset and checking for moving average crossovers of price with the last n days moving averages, and may grow to more complex querying involving volumes. My concern is, if I need all the collumns for the queries, will monetdb perform better or should I stick with postgresql plus standard. I'll post the pperformance results once I have copmp[leted populating the databases in postgresql......But I want to try out monetdb also, I know that the postgresql interpreter may perform very slow..... Anyways, thanks for this amazing product.....Also, when will the X100 be available as an extension in Monetdb --------------------------------------------------------- *Hi Jatin, thank you very much for your interest in MonetDB! We are glad to hear that you found MonetDB "way faster" than PostgreSQL with bulk loading your 250 MB dataset --- btw, which versions of MonetDB and PostgreSQL are you comparing on what kind of system (OS, hardware (CPU, RAM, I/O system))? With a simple select * from tablename, you basically evaluate to ability of both server and client to pump your 250 MB of data from the server to the client. That is probably an interesting measurement in case you mostly do select * from table queries. However, we do not consider such queries the "major challenges" for DBMSs and designed MonetDB not for plainly pumping all data from the server to the client in the most efficient way. Rather, we assume that the major part of data-management, i.e., processing (more) complex queries including selections, joins, aggregation, etc. are done by the DBMSs (server) and only the rather small results of such (analytical) queries are then sent to the server. Moreover, as opposed to "classical" row-stores, column-stores in general are not necessarily designed with a major focus on most efficiently re-constructing the whole table. They rather assume that most (analytical) queries usually only access a subset of all column of a table. Being able to access only the requested data and hence not having to carry-around excess-luggage of non-used columns during query processing is one of the key design differences of column-stores over row-stores. Hence, to speed up simple select * from tablename queries in MonetDB, you'd probably (at least) need to re-design and -implement MonetDB's client-server protocol (MAPI). We are curious, though, to also hear about your experiences with more complex queries that return much smaller (i.e., "more reasonable"?) result sets. Stefan ps: It is interesting to hear that the "vacuum" command in PostgreSQL had a significant impact on a simple select * from table query over bulk-loaded data, i.e., without any updates being performed --- I wouldn't know wht akind of "garbage" bulk-loading leaves behind that needs to be cleaned-up ... On Fri, Aug 21, 2009 at 07:18:46PM +0530, jatin patni wrote:* > Hi, I am in the process of evaluating two major databases....monetdb > and postgresql for building a backend database system for backtesting > on huge historical data sets around 100GB. I copied some test data(a > 250mb table) using bulk copy in both and monetdb was way faster. But > when I did a simple query "SELECT * from tablename", it took around 3 > minutes for 1 lakh rows via mclient and a gui interface (aqua studio > based on JVM simply said out of memory). The bulk copy file was in the > format collumns seperated by pipes in a text file. > While using postgresql, at first it was slow but once I did a > vacuum(function in postgresql), the (select * from tablename) was much > faster than monetdb. > > So, what am I missing here, Do I need to do something to enhance the > performance in Monetdb....... > I have high hopes from monetdb, so please help. > Thanks > > -- > Jatin Patni > Tel: 91 9911 649 657 > jatinpatni(a)gmail.com > www.jatinpatni.co.nr > > ------------------------------ ------------------------------------------------ > Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day > trial. Simplify your report design, integration and deployment - and focus on > what you do best, core application coding. Discover what's new with > Crystal Reports now. http://p.sf.net/sfu/bobj-july > _______________________________________________ > MonetDB-users mailing list > MonetDB-users(a)lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/monetdb-users > > > > > -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/<http://www.cwi.nl/%7Emanegold/> | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 | -- Jatin Patni Tel: 91 9911 649 657 jatinpatni(a)gmail.com www.jatinpatni.co.nr

2 1

[MonetDB-users] serial vs auto_increment
by Matthew Jones 22 Aug '09

22 Aug '09

After creating a table with a 'serial' type id field I noticed this when describing it: sql>CREATE TABLE "schtest"."testt" ("id" serial, ... sql>\d testt CREATE TABLE "schtest"."testt" ( "id" int NOT NULL DEFAULT next value for "schtest"."seq_4291", ... The following page: http://monetdb.cwi.nl/projects/monetdb/SQL/Documentation/Data-Types.html Says this about the serial data type: "special 64 bit integer (sequence generator)" and this about the 'int' data type: "32 bit integer" This looks like it created a table with a 32-bit integer sequence rather than a 64-bit integer sequence. If you use the auto_increment method you can set the type explicitly to be bigint, but should "serial" generate a bigint column also? 73, Matthew W. Jones (KI4ZIB) http://matburt.net

3 3

[MonetDB-users] Announcement: New Aug2009 feature release of MonetDB suite
by Stefan Manegold 20 Aug '09

20 Aug '09

Dear all, The MonetDB team at CWI/MonetDB BV are pleased to announce the new "Aug2009" feature release of the MonetDB suite of programs. This feature release is backward compatible with the previous releases (Nov2008 through May2009-SP2). Caveat: When upgrading from a release older than May2009 (i.e., Nov2008 through Feb2009-SP2), you need to move your write-ahead log following the "recommended" instructions for SQL (<http://monetdb.cwi.nl/Development/Releases/May2009/#SQL>) and/or XQuery (<http://monetdb.cwi.nl/Development/Releases/May2009/#XQuery>). More information on the new release is available at <http://monetdb.cwi.nl/Development/Releases/Aug2009/>. The sources and binaries are available at <http://monetdb.cwi.nl/Download/>. Enjoy! The MonetDB team at CWI/MonetDB BV. -- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |

1 0

Re: [MonetDB-users] MonetDB Installation
by listanand＠gmail.com 19 Aug '09

19 Aug '09

Thanks Stefan and Stefan :) Unfortunately, I still have not been able to install MonetDB. After installing PCRE and OpenSSL, I ran the install script again and I still get the error that OpenSSL library is not being found. This is clearly not the case as I even added it (OpenSSL's bin directory) to the system path, and am able to get to the OpenSSL prompt. Am I missing something here? Thanks again.

5 4

[MonetDB-users] MonetDB Installation
by listanand＠gmail.com 18 Aug '09

18 Aug '09

Hello all, I am trying to install MonetDB (from http://monetdb.cwi.nl/downloads/sources/May2009-SP2/MonetDB-May2009-SuperBa…) on Ubuntu Linux (Intrepid), and am running into one issue after another. First, after I ran the install script, I got an error saying that I need to install PCRE. After installing PCRE, I tried running the script again and then got an error saying that I need to install OpenSSL. Is there a way I could figure out what things are needed in advance, so I can install them all at one go? Alternatively, is there an easier way to install MonetDB? Thanks in advance. Andy

3 2

[MonetDB-users] may2009sp2 suberball patch
by Lazaros Koromilas 14 Aug '09

14 Aug '09

hello all, i needed to workaround a libtool `directory not ending in' error by adding an extra slash in a path. the ``patch'' is attached. i successfully built monetdb may 2009 sp2 with # ./monetdb-install.sh --enable-sql --enable-xquery on freebsd 7.2 release. in the attachment i include some installed packages/dependencies in case someone needs them. thanx, lazaros. -- http://www.ics.forth.gr/~koromil

1 0

[MonetDB-users] PHP XQuery error
by Gene Stevens 14 Aug '09

14 Aug '09

Hi everyone, I am a new MonetDB user. I am specifically interested in MonetDB's XQuery support with client access through PHP. I currently get parsing errors when trying any kind of XQuery through the PHP module. I'm wondering if this is a a bug in the client or if I am possibly doing something wrong. E.g.: #!/usr/bin/env php <?php $db = monetdb_connect('xquery', 'localhost', 50000, 'monetdb', 'monetdb') or die ("Failed to connect\n"); $query = 'count(1,2,3,4)'; $res = monetdb_query($query); ?> Results in: Warning: monetdb_query(): Query failed: parse error: syntax error, unexpected ;, expecting $end on line 1, column 15 (next token is `;') !parse error: XQuery parsing failed in /home/user/monet.php on line 6 ... for any variation of an XQuery. I have tried the server from the Ubuntu repository as well as I've built it from source with the same results. Here is my environment: PHP 5.2.6-3ubuntu4.1 with Suhosin-Patch 0.9.6.2 (cli) (built: Apr 23 2009 14:37:14) Ubuntu 9.04: Linux ubuntu 2.6.28-11-server #42-Ubuntu SMP Fri Apr 17 02:45:36 UTC 2009 x86_64 GNU/Linux Mserver --dbinit="module(pathfinder);" # MonetDB Server v4.30.4 # based on GDK v1.30.4 # Copyright (c) 1993-July 2008, CWI. All rights reserved. # Copyright (c) August 2008-2009, MonetDB B.V.. All rights reserved. # Compiled for x86_64-pc-linux-gnu/64bit with 64bit OIDs; dynamically linked. # Visit http://monetdb.cwi.nl/ for further information. # PF/Tijah module v0.13.0 loaded. http://dbappl.cs.utwente.nl/pftijah # MonetDB/XQuery module v0.28.3 loaded (default back-end is 'algebra') # XRPC administrative console at http://127.0.0.1:50001/admin MonetDB> Thanks for any insight! - Gene Stevens

4 11

Re: [MonetDB-users] MonetDB/XQuery Scaleability
by listanand＠gmail.com 14 Aug '09

14 Aug '09

Hi Wouter, Thanks for your note. I will definitely give it a try. 2 more questions though. Is MonetDB amenable to being accessed in parallel? I will need to run many queries on the fly, and will certainly need multiple connections to the database. Also, how well does MonetDB/XQuery work with Perl? Is it better to stick to Java/Python for now? Thanks again for your help. Andy

2 1

[MonetDB-users] ODBC error (specified driver could not be loaded due to system error 126)
by fadk 13 Aug '09

13 Aug '09

I read that there was a bug like this before, but its been fixed. Its seems like installing ODBC drivers is a problem for windows. Can you assist with this ? I am running winXP using the MonetDB 32 installer. http://sourceforge.net/tracker/?func=detail&atid=482468&aid=1902879&group_i… Also, is it possible to only build the client (to use mapi) on winXP given that I have MonetDB installed. ? Thanks for your help. -- View this message in context: http://www.nabble.com/ODBC-error-%28specified-driver-could-not-be-loaded-du… Sent from the monetdb-users mailing list archive at Nabble.com.

4 4

[MonetDB-users] Phrase searching with 'or'
by Roy Walter 13 Aug '09

13 Aug '09

Consider the following XQuery using two phrases: tijah:queryall("//p[about(., 'wind turbine') or about(., 'wind farm')]") It returns a restricted result set where only 'wind turbine' AND 'wind farm' are present. Substituting 'and' for 'or' in the query returns the same number of rows. Is this a bug? -- Roy

2 1

[MonetDB-users] Phrase searching with 'or'
by Roy Walter 13 Aug '09

13 Aug '09

Consider the following XQuery using two phrases: tijah:queryall("//p[about(., 'wind turbine') or about(., 'wind farm')]") It returns a restricted result set where only 'wind turbine' AND 'wind farm' are present. Substituting 'and' for 'or' in the query returns the same number of rows. Is this a bug? -- Roy

1 0