April 2015 - users-list

Cluster, How work ?
by Luciano Sasso 08 Apr '15

08 Apr '15

On a cluster using MonetDB, the documentation is not clear how it works. Data is automatically replicated between cluster nodes? There is an automatic load balancing? There sharding? Att, -- Luciano Sasso Vieira Gestor - Inteligência de Negócios luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 9706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

Sorting cluster's level queries
by José Raúl Pérez Rodríguez 06 Apr '15

06 Apr '15

Hi, I am new in monetdb. I was quering a multiplex funnel database and obviously (after read the description of multiplex funnel), the return values don't show up sorted. My question is: if using multiplex funnel databases queries can't be sorted, then how are sorted the queries at cluster level, i.e queries that retrieve data from 2 or more nodes? and how to perform that kind of quieries (not using a multiplex funnel). Thanks,

1 0

About "Zero-copy integration between MonetDB and R"
by Aris Setyawan 06 Apr '15

06 Apr '15

Hi all, First, thanks for implementing multi-core, parallel execution engine, ini MonetDB. This make MonetDB, the only opensource dbms, which have this feature. I'm sure, since MonetDB use mmap file, it is already use Zero-copy memory technique when loading data into memory for further processing. But, why the "Zero-copy integration between MonetDB and R" is not implemented in MonetDB release? -Aris

2 1

Building MonetDB from RPM on ROSA Desktop R4
by Brian Hood 05 Apr '15

05 Apr '15

Hi Guys, I know this isn't a support distro at all i'm just trying to get MonetDB to work on my ROSA Desktop R4 machine which is Linux / KDE with a Twist distro. http://pastebin.com/wiH6RPzQ Its all about this at the bottom. 1. cd . && /bin/sh ./config.status rpm.mk 2. config.status: creating rpm.mk 3. cd . && /bin/sh /home/brian/Downloads/rpmbuild/BUILD/MonetDB-11.19.7/buildtools/conf/missing automake-1.13 --foreign 4. configure.ac:372: error: required file 'buildtools/conf/compile' not found 5. configure.ac:372: 'automake --add-missing' can install 'compile' 6. Makefile:521: recipe for target 'Makefile.in' failed 7. make: *** [Makefile.in] Error 1 8. error: Bad exit status from /var/tmp/rpm-tmp.25756 (%build) 9. Automake the wrong version i'm not sure it seems to be upto date. Anybody any ideas on the off chance somebody has seen this before ? Regards, Brian Hood

2 2

Re: MonetDB, data loss in restart server
by Luciano Sasso 05 Apr '15

05 Apr '15

- OS is Debian 7 64-bit, in a VM in VMware virtualization System. - Hard disk 100G with 26% usage. - 5 cores. - 6G RAM. - Version MonetDB: MonetDB 5 server v11.15.17 "Feb2013-SP5" - Table: create table (id int, dt date, product varchar (50) .... etc, and another 30 columns between int and varchar. - Query: select dt, count (id) from table where produtct in (....) group by dt Message: 1 Date: Thu, 2 Apr 2015 23:16:39 +0200 From: Ying Zhang<Y.Zhang(a)cwi.nl> To: "Communication channel for developers of the MonetDB suite." <developers-list(a)monetdb.org> Cc:users-list@monetdb.org Subject: Re: MonetDB, data loss in restart server Message-ID:<6C2903C0-4399-462D-9D3F-822351DE1979(a)cwi.nl> Content-Type: text/plain; charset=windows-1252 Hello Luciano, Thanks for using monetdb, and sorry for the inconvenience. Would you please give us some background information about your setting: - which OS? - hardware spec. of your system - which monetdb version? - what does your query do? - when and how did the database stop? If the monetdb server stopped, did it give any error message? - what's at the end of the merovingian log? With kind regards, Jennie -- Luciano Sasso Vieira Gestor - Inteligência de Negócios luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 9706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

Re: MonetDB, data loss in restart server
by Ying Zhang 02 Apr '15

02 Apr '15

Hello Luciano, Thanks for using monetdb, and sorry for the inconvenience. Would you please give us some background information about your setting: - which OS? - hardware spec. of your system - which monetdb version? - what does your query do? - when and how did the database stop? If the monetdb server stopped, did it give any error message? - what's at the end of the merovingian log? With kind regards, Jennie > On Apr 01, 2015, at 06:46, Luciano Sasso <luciano(a)gsgroup.com.br> wrote: > > Hello, > > I have used the MonetDB in production for some time, and I have nothing to complain about, > are tables with more than 30 columns and 30 million records, do analysis through cubes in Pentaho / Saiku. > Have restarted the server several times, and never had problems with loss of data.But today, > after performing a query that was consuming a lot of machine, stopped the database, and when I started, > data from some columns were blank. How can it, will the data were still uncommitted? > when performing a query the MonetDB changes the data or reorganized? which may have occurred, I am concerned. > > > -- > <Slice_01.png> <Slice_02.jpg> > Luciano Sasso Vieira > Gestor - Inteligência de Negócios > > luciano(a)gsgroup.com.br | tel: 17 3353-0833 | cel: 17 9706-9335 > <Slice_04.png> www.gsgroup.com.br > <Slice_06.png> > > > Este email foi escaneado pelo Avast antivírus. > www.avast.com > > > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > https://www.monetdb.org/mailman/listinfo/developers-list

1 0

MonetDB in Production
by Luciano Sasso 02 Apr '15

02 Apr '15

Hi, I use MonetDB production together with Pentaho BI Server and Saiku, works very well and never had problems. I am currently about 30 million entries in a table of about 40 columns, occupying 9G disk. I'll use it now on other projects that this volume will increase a lot. On what basis of size and number of records you have experience and have arrived? Use in production? I was worried because a few days ago I had a corrupt basis, that is, some columns were blank after restarte the bank, do not know if is related to the data base or was disk failure, to join if I do not have evidence of failure disk, but I can not say. Att, -- Luciano Sasso Vieira Gestor - Inteligência de Negócios luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 9706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

Putting field description in SQL CREATE table
by Puthick Hok 02 Apr '15

02 Apr '15

Hi, I am working on developing a database web service layer for an open source plant/animal breeding platform. So far I rely on having field comment in CREATE TABLE SQL statement like CREATE TABLE "extract" ( "ExtractId" int NOT NULL auto_increment COMMENT 'Id of the DNA extract') ; for the online help. So far, we use MySQL for general storage, postgres for GIS and environment data storage. Both MySQL and Postgres support field comment in slightly different means. We are going to switch to MonetDB as our improved marker data storage. I have tested that the previous CREATE TABLE SQL would not work in MonetDB. Will MonetDB support this feature in the future? Regards, Puthick

3 2

Multiple nodes
by Jiří Nádvorník 02 Apr '15

02 Apr '15

Hi, Does MonetDB support some kind of installation over multiple nodes (servers)? How can I control data partitioning over these nodes? Jiri Nadvornik Astronomical Institute AV CR Stellar department Czech Republic <mailto:nadvornik.ji@gmail.com> nadvornik.ji(a)gmail.com

1 0

C++ user defined function
by Jiří Nádvorník 01 Apr '15

01 Apr '15

Hi, I'm trying to write a function in C++ and I thought I would just provide a makefile for it in my custom folder in MonetDB/sql/backends/monet5/CUSTOM. But it seems like all of the Makefiles in UDF sample are generated by the bootstrap. How do I get over this? I need to use external C++ libraries in the makefile.. Thank you for help. Best regards, Jiri Nadvornik Astronomical Institute AV CR Stellar department Czech Republic <mailto:nadvornik.ji@gmail.com> nadvornik.ji(a)gmail.com

4 9