- 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