- users-list - monetdb.org

[MonetDB-users] How to display the 'cool' mclient error messages?
by Stefan de Konink 19 Oct '09

19 Oct '09

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi, After trying to figure out for over an hour what could have possibly gone wrong with my database. And just before I started to complain out potential corruption I really wonder: If a mapilib user wants to get this message: SELECT: access denied for dbslayer to table 'sys.ietsanders' Could anyone provide a code snippet that returns that? printf("SELECT: access denied for dbslayer to table 'sys.ietsanders'\n"); is too easy... Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.13 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREKAAYFAkrcpQoACgkQYH1+F2Rqwn2x9wCfVXutknJ59KByQ+CzobrhrucK BCkAnRM6MiUcd/TwK47InveuD2rx8v7c =gUIR -----END PGP SIGNATURE-----

1 0

Re: [MonetDB-users] loading RDF data in MonetDB
by Medha Atre 17 Oct '09

17 Oct '09

Hi, Thanks for the reply. At this point, all I am looking for is to load RDF NTriples data -- treated as a 3 column table -- into MonetDB using "vertical partitioning" to index the data nicely (as I read about MonetDB being used for the same in different research papers recently.. e.g. http://portal.acm.org/citation.cfm?id=1453856.1453927 RDF-3X etc). I am not really looking for a great support for different RDF formats (as the data has already been cleaned into NTriples format using rdflib), I want to check the correctness of the results generated using my own querying tool. So can you please suggest me a method of treating the given RDF NTriples file as a simple "space separated" 3-column data file from which I can load the data into MonetDB creating the required indexes or "vertical partitions"? Querying with SQL front end is fine with me! Looking forward to your help. Medha > ------------------------------ > > Message: 5 > Date: Tue, 6 Oct 2009 10:19:57 +0200 > From: Lefteris <lsidir(a)gmail.com> > Subject: Re: [MonetDB-users] loading RDF data in MonetDB > To: Communication channel for MonetDB users > <monetdb-users(a)lists.sourceforge.net> > Message-ID: > <852badbc0910060119x4f125a06qd5fc7ed0c56035c(a)mail.gmail.com> > Content-Type: text/plain; charset=ISO-8859-1 > > Hi, > > there is a highly experimental module for MonetDB to load RDF data. > This is not activated in the stable release, and in order to use it > you will need to do some compilation on your own and possible report > back any problems you have. If you are willing to jump deeper in the > MonetDB experience I can guide you on how to do this. The module will > read any RDF format supported by the rdflib library and create a > triple store with appropriate indices. However, the only way to query > the triple store at this point is through the SQL front-end. > > regrads, > > lefteris > > On Tue, Oct 6, 2009 at 8:59 AM, Medha Atre <medha.atre(a)gmail.com> wrote: >> Hi, >> >> I intend to use MonetDB for some of my experimental work using RDF >> data. I was wondering if there is an easy way to load RDF data (in >> NTriples format) in MonetDB making use of the column-wise vertical >> partitioning of the RDF data, based on properties/predicates in the >> RDF data. >> >> Some pointers or help regarding this is much appreciated. >> >> I am sorry if this is not the correct forum to post this message. >> >> Thanks. >> Medha

8 24

[MonetDB-users] prepared exec did not translate date string
by Allen Zhang 16 Oct '09

16 Oct '09

Hi, there, We are testing the Aug SP1 (v5.14.2) release, it seems the exec did not translate the date string, please run attached sql against Aug SP1, it give out the following error, the same script works file on mserver v5.10.4 (May SP1). Sounds like a bug to me. 15:19:53 [CREATE - 0 row(s), 0.000 secs] Command processed. No rows were affected 15:19:53 [SELECT - 3 row(s), 0.000 secs] Result set fetched 15:19:54 [PREPARE - 1 row(s), 0.000 secs] Result set fetched 15:19:54 [EXEC - 0 row(s), 0.000 secs] SQLException:sql.prepare:wrong argument for prepared statement (expected date instead of char) 15:19:54 [EXEC - 0 row(s), 0.000 secs] current transaction is aborted (please ROLLBACK) 15:19:54 [EXEC - 0 row(s), 0.000 secs] current transaction is aborted (please ROLLBACK) 15:19:54 [EXEC - 0 row(s), 0.000 secs] current transaction is aborted (please ROLLBACK) 15:19:54 [COMMIT - 0 row(s), 0.000 secs] COMMIT: failed ERROR: COMMIT: transaction is aborted, will ROLLBACK instead 15:19:54 [SELECT - 3 row(s), 0.015 secs] Result set fetched 15:19:54 [DROP - 0 row(s), 0.000 secs] Command processed. No rows were affected ... 10 statement(s) executed, 7 row(s) affected, exec/fetch time: 0.015/0.000 sec [3 successful, 2 warnings, 5 errors] Thanks for the attention. Allen

2 1

[MonetDB-users] BATpropcheck exception
by Alex Bo. 15 Oct '09

15 Oct '09

Hi, I haven't been able to reproduce this, but when running an INSERT query I got: !MALEXCEPTION: !ERROR: BATpropcheck: ... tuples seqbase of dense oid bat is wrong! 0 != 12306 I am running Aug09 SP1 compiled from CVS on Windows. What could have caused this error? Thanks. -- View this message in context: http://www.nabble.com/BATpropcheck-exception-tp25909476p25909476.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Use cases for seperate servers vs single database
by Stefan de Konink 11 Oct '09

11 Oct '09

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA512 Hi, What is the developer perspective of running a single database with a single mapi interface but different users (and rights) versus multiple databases having each one user. Is there a good reason not to merge databases? I understand that each MonetDB instance thinks it can access all the memory on the system available, that would indicate it might be better to run a single server. Could someone elaborate on the above? Stefan -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEAREKAAYFAkrQsBgACgkQYH1+F2Rqwn3olACffKnjqdhef+fXkmKwmdOLvJkK ltgAnAw/MIIBHfXokLAbV3sA9RMUG/Hw =2fGw -----END PGP SIGNATURE-----

2 2

[MonetDB-users] MonetDB/XQuery with Java/Perl
by listanand＠gmail.com 09 Oct '09

09 Oct '09

Hi all, I am new to MonetDB/XQuery, and have a question to ask. Actually, I am new to MonetDB/XQuery, XML, SOAP, RPC, and XQuery also, and so you can very well imagine how overwhelmed I must be at this point :( I do not need super efficient query processing, but what I do certainly need is a convenient hassle free programmatic access to the XQuery database. I looked at the documentation and it appears that the Perl and Java APIs still need some work, and are not ready for prime time. Is that correct? Also, do I need to learn SOAP, RPC etc to be able to issue XQueries from my program? Thanks in advance. Sorry if I seem grumpy (I am!). Andy

1 0

[MonetDB-users] mapilib latin1
by wilfried＠hafner.ws 09 Oct '09

09 Oct '09

Hi! I have a table with a varchar(100) column, when I connect to the server with mclient.bat -Elatin1 option I'm able to insert and display characters like ä and ö correctly. But I have problems to do the same with a c++ app and the mapilib. Does anyone have some hints? regards, Wilfried

2 2

[MonetDB-users] Help with table sizes
by david85 08 Oct '09

08 Oct '09

Hello, I am currently trying to figure out how I can determine the size, i.e. the disk space, of the different tables. I know that they are stored in the dbfarm/database_name/bat folder, but I don't know which folder holds the data for which table. I looked at the manual but the bbp.getDiskSpace command didn't work (or maybe I used it wrong). I have also searched for this topic, but there was no concrete answer. Thank you in advance. Best Regards -- View this message in context: http://www.nabble.com/Help-with-table-sizes-tp25728470p25728470.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 2

[MonetDB-users] Support for ANSI 1992/99 BIT
by McKennirey.Matthew 08 Oct '09

08 Oct '09

Although ANSI 2003 eliminated the BIT data type, I was wondering if anyone has developed support for this in MonetDB. Specifically we would like to store UUIDs in a column, as a 128 bit BIT type. Storing a UUID in its canonical string form (36 characters = 288 bits) seems inefficient. We would also like to consider using bit masks for access control. Thanks

1 0

[MonetDB-users] mapilib on windows
by wilfried＠hafner.ws 08 Oct '09

08 Oct '09

Hello! I have a question on getting the mapi working on windows... I downloaded the MonetDB-client-1.32.2.zip from the sources directory. I tried now to open the solution file in the NT directory but its not possible, I use vc++ 2008 express. What version of vc++ should I use? Is there an existing .lib in one of the other downloadable packages? I would like to create a sql driver for qt4 in c++... Kind Regards, Wilfried

2 2