Dear Jenni,
- Here you have the output of 'mserver5 --version'
MonetDB 5 server v11.7.5 "Dec2011" (32-bit, 32-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2012 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 3.4GiB available memory, 2 available cpu cores
Libraries:
libpcre: 8.12 2011-01-15 (compiled with 8.12)
openssl: OpenSSL 1.0.0e 6 Sep 2011 (compiled with OpenSSL 1.0.0e 6 Sep
2011)
libxml2: 2.7.8 (compiled with 2.7.8)
Compiled by: root@dev.monetdb.org (i686-pc-linux-gnu)
Compilation: gcc -O3 -fomit-frame-pointer -pipe -O2 -Wall
Linking : /usr/bin/ld -Wl,-Bsymbolic-functions
- The DDL can be download from the BSBM site I gave the link on the
previous email. However, here you have the file :
http://dl.dropbox.com/u/531378/bsbm/bsbm250k-monetdb-ddl.zip
Regards
Freddy
2012/3/6 Ying Zhang
Hello Freddy,
On Tue, Mar 06, 2012 at 02:31:37PM +0100, Freddy Priyatna wrote:
Dear all,
I've been using MonetDB version 5 on Ubuntu machine for evaluating BSBM
Which monetdb version are you using ('5' is not the version of the software package)? Can you please send us the output of the command 'mserver5 --version'?
queries. The dataset and queries can be found here[1].
Can you please give us the CREATE TABLE statements? We can not run your queries without creating the tables first.
It seems that there are some queries that are not supported on MonetDB : 1) SELECT p.nr, p.label FROM product p, producttypeproduct ptp WHERE p.nr=ptp.product AND "productType"=35 AND "propertyNum1">500 AND "propertyNum3"<2000 AND 168 IN (SELECT "productFeature" FROM productfeatureproduct WHERE productfeatureproduct.product=p.nr) AND 147 NOT IN (SELECT "productFeature" FROM productfeatureproduct WHERE product=p.nr)
From the error, the subquery seems can't refer to the table alias "p".
2) SELECT distinct p.nr, p.label FROM product p, product po, (Select distinct pfp1.product FROM productfeatureproduct pfp1, (SELECT "productFeature" FROM productfeatureproduct WHERE product=2) pfp2 WHERE pfp2."productFeature"=pfp1."productFeature") pfp WHERE p.nr=pfp.product AND po.nr=2 AND p.nr <> po.nr AND p."propertyNum1" < (po."propertyNum1"+120) AND p."propertyNum1" > (po."propertyNum1"-120) AND p."propertyNum2" < (po."propertyNum2"+170) AND p."propertyNum2" > (po."propertyNum2"-170) This is strange, because if I just comment one of the last 2 lines, the query works. But the last two lines can't be used together.
3) SELECT nr, label FROM product WHERE label like "%countries%"; It seems that MonetDB doesn't support regex.
4) SELECT * FROM (select label from product where nr=2) p left join ((select o.nr as onr, o.price, v.nr as vnr, v.label from offer o, vendor v where 2=o.product AND o.vendor=v.nr AND v.country='GB' AND o."validTo">'2008-07-01') ov right join (select r.nr as rnr, r.title, pn.nr as pnnr, pn.name, r.rating1, r.rating2 from review r, person pn where r.product=2 AND r.person=pn.nr) rpn on (1=1)) on (1=1); It seems that MonetDB can't do join with true condition because when I tried to run a simple query : SELECT * FROM product p RIGHT JOIN offer o ON (1=1) Then MonetDB gives an error.
With the latest release, i.e., Dec2011-SP1, this simple query seems working:
$ mclient Welcome to mclient, the MonetDB/SQL interactive terminal (unreleased) Database: MonetDB v11.7.8 (unreleased), 'demo' Type \q to quit, \? for a list of available commands auto commit mode: on sql>create table t1 (x int, y int, v float); operation successful (25.398ms) sql>create table t2 (x int, y int, v float); operation successful (26.987ms) sql>SELECT * FROM t1 t3 RIGHT JOIN t2 t4 ON (1=1); +---+---+---+---+---+---+ | x | y | v | x | y | v | +===+===+===+===+===+===+ +---+---+---+---+---+---+ 0 tuples (4.595ms)
Regards,
Jennie
Could anyone please help me how to run the queries above?
Many thanks in advance. Freddy
[1]
http://www4.wiwiss.fu-berlin.de/bizer/BerlinSPARQLBenchmark/spec/ExploreUseC...
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users