- users-list - monetdb.org

[MonetDB-users] COPY command syntax
by Roman Sokolyuk 30 Oct '09

30 Oct '09

Hi, Could someone please point out to me what is wrong with the way I am using the COPY utility? Here is what I typed: COPY 2 RECORDS INTO my_table FROM (C:\MyDir\MyFile.txt) USING DELIMITERS field_separator ',' record_separator ','; I got this error: *!syntax error, unexpected IDENT, expecting STRING in: "copy 2 records !into my_table from (c" 0 tuples*

4 9

[MonetDB-users] Announcement: New Aug2009-SP2 bugfix release of MonetDB suite
by Sjoerd Mullender 30 Oct '09

30 Oct '09

The MonetDB team at CWI/MonetDB BV is pleased to announce the Aug2009-SP2 bug fix release of the MonetDB suite of programs. This is the second bug fix release for the Aug2009 release. More information on this release can be found at <http://monetdb.cwi.nl/projects/monetdb//Development/Releases/Aug2009/#Aug20…>. The sources and binaries are available at <http://monetdb.cwi.nl/projects/monetdb/Download/>. -- Sjoerd Mullender

1 0

[MonetDB-users] dbfarm unusable after computer crash
by Alex Bo. 27 Oct '09

27 Oct '09

Hi, I am using Aug09-SP1 on Windows from CVS. While working with MonetDB my computer stopped responding, so I shut it down forcefully. Then after restarting, I couldn't start my dbfarm. The server is saying: !ERROR: BBPinit: old BBP without version number !ERROR: dump the database using a compatible version, !ERROR: then restore into new database using this version. How can I save my data? Or is it forever unusable? Thanks. -- View this message in context: http://www.nabble.com/dbfarm-unusable-after-computer-crash-tp26078901p26078… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] blobs with mapilib
by Wilfried Hafner 27 Oct '09

27 Oct '09

Hi! Is there an example how to load a blob with the mapilib? I'm using mapi_query_array, after calling there is an assertion failure in Mapi.mx on line 3373, it works for small blobs (I tried with 4, 8 bytes) but not with a 4kB picture. Thanks, Wilfried

1 0

[MonetDB-users] server does not start anymore
by wilfried＠hafner.ws 24 Oct '09

24 Oct '09

Hello! For some testing purposes, I created a file with 63.158.399 rows and tried to load it into a table with following structure: create table logtest ( id bigint, dim_year smallint, dim_month smallint, dim_day smallint, dim_hour smallint, dim_min smallint, dim_sec smallint ); I loaded the data in pieces of 20.000.000 rows with the 'copy into' command. At the last 3158399 there was an error, the connection to the server terminated, the server crashed. I restarted the server and the error message ERROR: HEAPextend: failed to extend to 480000000 for 01\14\11401tail was displayed. I tried to restart again, but its not possible anymore, the server immediatly returns and there is no error message... C:\MonetDB\MonetDB5>MSQLserver.bat # MonetDB server v5.14.2, based on kernel v1.32.2 # 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:\MonetDB\MonetDB5\etc\monetdb5.conf) # Listening for connection requests on mapi:monetdb://127.0.0.1:50000/ # MonetDB/SQL module v2.32.2 loaded I know I can reinstall the server, but I would like to know the problem. Are there too much rows for the logtest table? There are about 10 other tables in the database, with 10 - 100 rows. As you can see from above, I'm using windows vista, 32 bit... The current size of the dbfarm folder is 1,52 GB, and the size of the file I tried to load is 1,72 GB. Thank you, Wilfried

2 4

[MonetDB-users] union bug?
by Allen Zhang 23 Oct '09

23 Oct '09

Hi, There, We encounter such a strange problem in the union in monetdb, when run attached sql. The where condition did not get applied towards the last union recordset. So the result from the attached sql is like 2009ABC 2008ABC 2007ABC ADD Notice the ADD get into the result!! But when we remove the last union of ADD, then the ABD gets into the result. Looks like the where condition gets ignored in the last union. Regards Allen

2 1

[MonetDB-users] mclient with mal
by Romulo Goncalves 22 Oct '09

22 Oct '09

Hello, Could someone explain what I could have done wrong to get this message when I start mclient: -bash-3.2$ ~/MonetDB/scripts/mclient current debug mal xchange_challenge: frontend mal not found I have the latest version of the cvs head. In the same machine there is another Mserver running. I used a different port for mine, i.e., there is two mservers running on the same machine... Regards, Romulo

2 3

[MonetDB-users] plz help
by ahmed_moon 22 Oct '09

22 Oct '09

Draw a Context as well as Level 0 Data Flow Diagram (DFD) of a Shop Sale Management System for a company sailing shops in different parts of country. The Shop Sale Management System works as follows: Ø Customer Places order. System checks availability of the customer in customer file (If he / she is already a customer). If found, then approved otherwise a new customer is created. Here new customer’s info is sent to ledger file. Ø Then the availability of shops is checked in the stock. If found, an Invoice is generated. Invoice info is sent to the customer, stock, ledger as well as sales department. Ø If shop is not available at this time, then this info is also sent to the customer. Purposes: Ensure that you can analyze existing manual system and can draw Data Flow Diagrams of any proposed system. Before Starting: Detail study of existing system. Rules for drawing DFDs. Differentiate different levels of DFDs. -- View this message in context: http://www.nabble.com/plz-help-tp26004897p26004897.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] bulk upload
by Roman Sokolyuk 22 Oct '09

22 Oct '09

Is there a facility in MonetDB for batch upload of large sets of data, instead of executing many INSERT statements and inserting one row at a time?

3 2

[MonetDB-users] Star Schema and MonetDB
by Roman Sokolyuk 21 Oct '09

21 Oct '09

Do I have to create Star Schema in Monet DB, or is it specially optimized for running data analysis on Just one large denormalized table?

2 1

[MonetDB-users] Invalid Identifier
by Roman Sokolyuk 21 Oct '09

21 Oct '09

So I am trying to import some data from a different DB to Monet. I created a large file with INSERT statements almost 7K insets. I saved it in a .sql file and tried importing it using \< [file_name] - that gave me almost 7K of Invalid identifier error messages. When I try just one insert out of that file it works fine though. Also, I compared my sql file to the VOC tutorial sql file and the only difference I see is that in mine each INSERT is one its own line - which means it has a newline character at the end of each line. Could this be creating a problem?

1 0

[MonetDB-users] How can I truncate a table
by Roman Sokolyuk 21 Oct '09

21 Oct '09

Is there an equivalent in MonetDB of truncating or emptying a table of all data?

2 2

[MonetDB-users] timestamp conversion failed -How can I convert a char string to a timestamp
by Roman Sokolyuk 21 Oct '09

21 Oct '09

Hi, I am trying to insert the following value into a timestamp column: '2/5/2008 4:05:31 PM' and I get the error message: !SQLException:timestamp:conversion of string '2/5/2008 4:05:31 PM' failed I would like to convert that date string into a timestamp type - is there a function in Monet to do that?

2 2

[MonetDB-users] SQL: Connect To statement, help request
by Bart Buter 21 Oct '09

21 Oct '09

I could use some pointers since I have trouble getting something started I have 2 machines ow138 ip:146.50.7.21 and ow139 ip:146.50.9.30 Both machines run a database with the name of the machine Merovingian is running on both systems >>monetdb discover location mapi:monetdb://ow139:50000/ow139 mapi:monetdb://ow138:50000/ow138 I would like to connect these databases using SQL: CONNECT TO statement, however I cannot seem to get past syntax errors etc. Thus something like >>mclient -lsql -d ow138 sql> CONNECT TO ow139 ..... Can someone please help me fill in the dots

2 1

[MonetDB-users] Question on Usage
by Roman Sokolyuk 21 Oct '09

21 Oct '09

Hi, I am evaluating MonetDB for OLAP purposes and had some questions about usage: Please, be patient with me as I am rather new to this area... 1. If I were to build a data warehouse in MonetDB, would I have to store data in a different manner than in any other RDBMS? From what I understand, in data warehousing data should be denormalized, but besides that, do I need to familiarize myself with any new paradigms specific to MonetDB? For example, If my firsm sells 4types of vehicles - RV's, small cars, and motorcycles - and I want to create reporting which can be limited to only one of them or all of them put together, would I have to create 3 tables - one for each type of vehicle, but which have the same columns? Say RVs: make_year, size, brand car: make_year, size, brand motorcylce: make_year, size, brand? 2. Let's say I wanted to also keep aggregate information on the purchase of those vehicles, would I keep the aggregate data in a separate table, or use MonetDB to compute it? I guess what I am struggling to understand is: is usage of monet db for a Java developer radically different from other RDBMS's like MySQL or Oracle, or is it the same, and the OLAP strength is only the result of MonetDB's internals? Thanks,

1 0

[MonetDB-users] create temp table privileges
by magicrobotmonkey 20 Oct '09

20 Oct '09

I am trying to set up monet as a backend to our system for reporting. I've got merovigian running, with a database created, and I've added a schema and user to that db via mclient: CREATE USER "test" WITH PASSWORD 'password' NAME 'Test User' SCHEMA "sys"; CREATE SCHEMA "test" AUTHORIZATION "test"; ALTER USER "test" SET SCHEMA "test"; Now, I can do all kinds of things in the test schema with this user. What I can't do is create temporary tables: Error in query: CREATE TABLE: insufficient privileges for user 'test' in schema 'tmp'. I cannot for the life of me figure out how to give this user create table privileges in tmp. -- View this message in context: http://www.nabble.com/create-temp-table-privileges-tp25981635p25981635.html Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] default database
by Roman Sokolyuk 20 Oct '09

20 Oct '09

Hi, I installed Monet, but I did not create a database, and now I want to connect SQuirrell, but I need to know the name of the database to put in the URL. I imported the voc data, so there must be a database set up already. Is there a way I can find out the name of the database I am logged into?

2 2

[MonetDB-users] Hibernate?
by Roman Sokolyuk 20 Oct '09

20 Oct '09

Does Monet integrate with Hibernate?

1 0

[MonetDB-users] Cannot import the VOC data
by Roman Sokolyuk 20 Oct '09

20 Oct '09

Hi, I extracted the sql voc data file, but when I run \< voc_dump.sql on the command line I get the error: *voc_dump.sql: cannot open* I extracted it directly into the MonetDB installation directory, alongside mclient.bat.

3 4

[MonetDB-users] Cannot start mclient on Windows
by Roman Sokolyuk 20 Oct '09

20 Oct '09

Hi, I am running Vista 64. I installed the 64 msi of monetdb. When I start the client from the Start menu it works fine, but when I try to run mclient --help for example in a simple command prompt window I get a Windows error message: "This application has failed to start because libMapi.dll was not found. Re-installing the application may fix the problem". Could you please suggest something? Thanks.

2 2

[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