April 2015 - users-list

More information about data loss in Bugzilla
by Luciano Sasso 20 Apr '15

20 Apr '15

I found this bug related to loss of data, is exactly what my bug, it was not clear in bugzilla if it was resolved or not, can tell me? I'm very insecure with MonetDB. https://www.monetdb.org/bugzilla/show_bug.cgi?id=3271 Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

More information about data loss
by Luciano Sasso 20 Apr '15

20 Apr '15

Hi, Some more details about data loss in MonetDB, I saw all that yours have commented, and also is aware that I am not with the latest version (update in ), but is a serious mistake in the previous version . Have a comment that said a data synchronization correction was made, has to do with the change or reorganization of data, even when it is only run queries? Will by defragmentation reasons (vacum PostgreSQL), or index creation, the data is changed / moved and in this case can be lost. The query for example is "select product from products where cod_product in (123,12434,33434)", only the data in this column (cod_product) were lost (went blank), and still only clinhas related codes on in. The only thing out of the ordinary has happened is that the ongoing connection was aborted, Pentaho was killed forced, aborting the connections, but the MonetDB service has stopped "stop MonetDB dw", which usually stopped, when start "moentdb start dw", rose correctly without errors, but took a long time to rise, very much, and then went to see the lost data. Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

MAL aggregate function difficulty
by Puthick Hok 20 Apr '15

20 Apr '15

Hi, I'm trying to define an aggregate function in MonetDB to concatenate rows in select group by (GROUP_CONCAT in MySQL). Postgres does not have this but there is an example to define this function. I'm starting to use monetdb from mysql thanks to MonetDB performance for large data sets. For some small tables, we have the feature to allow users to store small amount of custom data in rows and have a web service to convert rows into columns. We have this feature because we can do it in MySQL and Postgres using GROUP_CONCAT. I'm working on an open source breeding system which stores breeding data in MySQL, environment data in Postgres and now marker data in MonetDB in Australia. The system is called KDDart. Going back to my problem is that there is the same question with GROUP_CONCAT about 3 years ago. I have been googling and trying based on the information available for 2 days now. I have learnt how to define a MAL function and make it available in SQL mode by saving it in the autoload. However, when it comes to define and write a MAL aggregate function. I'm unable to find any step-by-step example. I could not start successfully with a simple aggregate solution. I google further that we a documentation on monetdb website about defining an aggregate function in R. I installed R and recompile my MonetDB source (MonetDB-11.19.9) on my openSuSe 12.2 with a pre-compiled R (R-base-2.15.1-1.1.4.x86_64). I followed the instruction to enable rintegration and compile successfully. R integration is loaded with mserver5 instruction. But when using monetdbd it says 'set: no such property: embedr'. I did bit of C debugging but I only got Segmentation fault. I don't know what you could do to help me out. I wish I could write the GROUP_CONCAT MAL function and being able to define it permanently in .mal file and being able to link it to the SQL. I hope you can help me out. Thanks in advance. Puthick

3 3

MonetDB Cluster
by Luciano Sasso 17 Apr '15

17 Apr '15

Hello, I read all posts about cluster in MonetDB, but dont understand, I will make some specific quaestions, I think it will be more objective: 1- MonetDB makes automatic replication between nodes? 2- The writing is performed in a just node and this replicate to the other? 3. The reading can be done on any node? 4- There is a router that distributes queries between the nodes? 5- If a query from a client is very cost, this query can be distributed between nodes? 6- MonetDB makes sharding transparently? 7- How to funnel and multiplex ? Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

3 2

MonetDB vs Vertica CE
by Luciano Sasso 17 Apr '15

17 Apr '15

Hi, The team of staff this questioning me about using Vertica, but it has limitations on the CE version. Someone already used the Vertica has some advantage over MonetDB? -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

7 10

MonetDB vs Vertica CE
by Luciano Sasso 17 Apr '15

17 Apr '15

Hi, thanks for awnsers. Precisely, I tried last year to deploy Vertical, but had trouble install and configure, since the MonetDB, was simply install and use, so do I use to this day with a database analytical about 30G, and 50 million records in the main table. I use Pentaho (Saiku) to explore the data, and also queries for creating dashboards. Now I pretty increase the volume of data, so that is posted another question about MonetDB clustered, it is the only thi still worries me, if I need to scalling. I dont think I still need something like HBase / Hadoop. Also have questioned me about using MongoDB, but from what I saw on MongoDB, needs a lot of programming to performance aggregations etc. with the MonetDB it is transparent. Today my data for analysis in MonetDB are fully denormalized not use model schema star. I see that many proposes the architecture with MongoDB for DW and Vertica or MonetDB, for analysis, but that think with volume that I have, I can use the MonetDB dw as well. I see there are many things about trying to force the use of Big data tools without really need it. Att, On 16/04/2015 10:38, users-list-request(a)monetdb.org wrote: > Send users-list mailing list submissions to > users-list(a)monetdb.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://www.monetdb.org/mailman/listinfo/users-list > or, via email, send a message with subject or body 'help' to > users-list-request(a)monetdb.org > > You can reach the person managing the list at > users-list-owner(a)monetdb.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of users-list digest..." > > > Today's Topics: > > 1. Re: MonetDB vs Vertica CE (Ruben Silva) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 16 Apr 2015 14:37:47 +0100 > From: Ruben Silva <ruben.silva(a)cortex-intelligence.com> > To: Communication channel for MonetDB users <users-list(a)monetdb.org> > Subject: Re: MonetDB vs Vertica CE > Message-ID: > <CAER5Ptm+M8e1B5r0bgXKnMrADGhW+ch6Wcdy5co1jw8b=CehCA(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > Hello Luciano, > > I don't have a full grasp of the new stuff introduced into MonetDB in the > last year, but as far as I know there are still major differences between > the two systems for me the most important is scalability. Vertica has no > single point of failure when working as a cluster. However the CE version > is limited to three nodes, so scalability is also limited in that case. > > Vertica relies heavily on projections as a way to improve performance. If > your data model is relatively stable it is something fairly easy to use, > but if your data model changes at a high rate you will have a considerable > amount of additional work managing the projections. Also if you use many > projections they will hurt your DML statements performance. > > MonetDB feeds on CPU and has no boundaries for its appetite, consuming as > much resources as possible in order to respond to a single statement. That > can be very good or very bad, it depends on your use case. Vertica has > resource pools that are used to regulate the stuff (IO, Ram, CPU) that each > query is allowed to use. > > I don't know your use case (and that is crucial for a good advice), but if > you are considering a scenario where you have a single machine for the > database system, then go with MonetDB without any doubt. It is just faster > and simpler. > > Cumprimentos (Regards), > > 2015-04-16 14:04 GMT+01:00 Luciano Sasso <luciano(a)gsgroup.com.br>: > >> Hi, >> >> The team of staff this questioning me about using Vertica, but it has >> limitations on >> the CE version. Someone already used the Vertica has some advantage over >> MonetDB? >> >> -- >> Luciano Sasso Vieira >> Data Scientist & Solutions Architect >> >> luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 >> 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br >> >> >> ------------------------------ >> [image: Avast logo] <http://www.avast.com/> >> >> Este email foi escaneado pelo Avast antiv?rus. >> www.avast.com >> >> >> _______________________________________________ >> users-list mailing list >> users-list(a)monetdb.org >> https://www.monetdb.org/mailman/listinfo/users-list >> >> >

2 1

MonetDB clustered
by Luciano Sasso 16 Apr '15

16 Apr '15

Hi, I have a question about MonetDB clustered 1- It only replicates data between nodes? 2- He replicates data between nodes doing sharding? 3- When a query is sent to the cluster, it is processed by one node just or distributed by several nodes? 4- Cluster is related to multiplex-funnel? Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

2 1

Re: MonetDB vs Vertica CE
by Luciano Sasso 16 Apr '15

16 Apr '15

Hi, Right, but in the case when you take the data 30 minutes, you take all the data, and the bank have to see what should be changed or inserted? is not better you take only the new data in this way will always be inserted? I do it today Att, On 16/04/2015 10:47, users-list-request(a)monetdb.org wrote: > Send users-list mailing list submissions to > users-list(a)monetdb.org > > To subscribe or unsubscribe via the World Wide Web, visit > https://www.monetdb.org/mailman/listinfo/users-list > or, via email, send a message with subject or body 'help' to > users-list-request(a)monetdb.org > > You can reach the person managing the list at > users-list-owner(a)monetdb.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of users-list digest..." > > > Today's Topics: > > 1. Re: MonetDB vs Vertica CE (shamsul hassan) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 16 Apr 2015 14:47:46 +0100 > From: shamsul hassan <shamsulbuddy(a)gmail.com> > To: Communication channel for MonetDB users <users-list(a)monetdb.org> > Subject: Re: MonetDB vs Vertica CE > Message-ID: > <CAONo-du24VrQ_PR4nzNq7rT7Uw47fKQb5Pr376UWEDmTbCN7qQ(a)mail.gmail.com> > Content-Type: text/plain; charset="utf-8" > > there is only one thing which has stopped me for using MonetDB in > production is the lack of UPSERT operation. > In my case new data comes every 30 mins and I cannot truncate and load the > whole table again. Ideally an UPSERT would have helped here as it will only > touch those records which are new or changed without truncating the whole > table. > > I raised the question few days before in Community list but didn't get any > useful answer. > > If i get any workaround for these UPSERTS the i would be as happy as pig in > dirty water :) > > Thanks > > > On Thu, Apr 16, 2015 at 2:37 PM, Ruben Silva < > ruben.silva(a)cortex-intelligence.com> wrote: > >> Hello Luciano, >> >> I don't have a full grasp of the new stuff introduced into MonetDB in the >> last year, but as far as I know there are still major differences between >> the two systems for me the most important is scalability. Vertica has no >> single point of failure when working as a cluster. However the CE version >> is limited to three nodes, so scalability is also limited in that case. >> >> Vertica relies heavily on projections as a way to improve performance. If >> your data model is relatively stable it is something fairly easy to use, >> but if your data model changes at a high rate you will have a considerable >> amount of additional work managing the projections. Also if you use many >> projections they will hurt your DML statements performance. >> >> MonetDB feeds on CPU and has no boundaries for its appetite, consuming as >> much resources as possible in order to respond to a single statement. That >> can be very good or very bad, it depends on your use case. Vertica has >> resource pools that are used to regulate the stuff (IO, Ram, CPU) that each >> query is allowed to use. >> >> I don't know your use case (and that is crucial for a good advice), but if >> you are considering a scenario where you have a single machine for the >> database system, then go with MonetDB without any doubt. It is just faster >> and simpler. >> >> Cumprimentos (Regards), >> >> 2015-04-16 14:04 GMT+01:00 Luciano Sasso <luciano(a)gsgroup.com.br>: >> >>> Hi, >>> >>> The team of staff this questioning me about using Vertica, but it has >>> limitations on >>> the CE version. Someone already used the Vertica has some advantage over >>> MonetDB? >>> >>> -- >>> Luciano Sasso Vieira >>> Data Scientist & Solutions Architect >>> >>> luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 >>> 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br >>> >>> >>> ------------------------------ >>> [image: Avast logo] <http://www.avast.com/> >>> >>> Este email foi escaneado pelo Avast antiv?rus. >>> www.avast.com >>> >>> >>> _______________________________________________ >>> users-list mailing list >>> users-list(a)monetdb.org >>> https://www.monetdb.org/mailman/listinfo/users-list >>> >>> >> _______________________________________________ >> users-list mailing list >> users-list(a)monetdb.org >> https://www.monetdb.org/mailman/listinfo/users-list >> >> >

1 0

MonetDB with R Integration for Windows Issues
by Bogdan Dimitrov 15 Apr '15

15 Apr '15

Hello everyone, I have been trying to get Embedded R in MonetDB to run on Windows 7 and I ran into a bunch of problems. I was wondering if anybody else has been able to get it running or whether there are better workarounds for the issues that I found. I am using manually built MonetDB version 11.19.9 with R integration enabled. The problems I had to fix seem to stem from the fact that the MonetDB is built using the VS2010 compiler, while the R assemblies are built with the MinGW compiler, so sometimes the two do not play nicely together and the server crashes with access violation errors on several occasions. After some debugging of both MonetDB and R source I identified the following problems: 1. The call in rapi.c line 373: R_tryEvalSilent(VECTOR_ELT(R_ParseVector(mkString(rapiinclude), 1, &status, R_NilValue), 0), R_GlobalEnv, &evalErr); fails with an access violation error. The problem is that the path contained in the char array called rapiinclude uses backslashes (Windows style), while the R code expects a UNIX style path with forward slashes. I added a bit of code to rapi.c that replaces the backslashes with forward slashes in the path to work around this issue. 2. The call in rapi.c line 742: fprintf(stdout, "# MonetDB/R module loaded\n"); fails with an access violation (as well as the rest of fprintf calls in rapi.c). Passing file handles across dll boundaries can cause problems even when same compiler is used, here it is passed between dlls built with different compilers (VS2010 compiled lib_rapi.dll to MinGW compiled R.dll). I replaced all fprintf calls with printf to work around this issue. Fixing the above issues I managed to run MonetDB with embedded R on Windows 7 and all the R scripts I tried seemed to work fine until I tried to use an R library that had to be downloaded first automatically using the overloaded library() function as described in https://www.monetdb.org/content/embedded-r-monetdb . 3. The call in rapi.R line 32: install.packages(package,repos=c("http://cran.rstudio.com/"),lib=.rapi.libdir,quiet=T) causes access violation as well, but I have not been able to find a workaround for this yet (apart from manually downloading the R package and dropping it in rapi_packages folder in dbfarm, so no downloading needs to happen). These should be Windows specific issues as MonetDB and R can be compiled with the same compiler for *NIX systems, while the MonetDB build instructions for Windows explicitly state that there is no longer support for compilers other than Microsoft Visual Studio's. I would appreciate it if anybody can help me solve the problem with downloading R libraries or knows a way to get the R integration running on Windows without the custom code changes described above. Best regards, Bogdan Dimitrov ________________________________

2 1

segfault in function when return table from IF (or any code branch)
by Caroptions Caroptions 14 Apr '15

14 Apr '15

DROP FUNCTION test(text); CREATE FUNCTION test(a text) RETURNS table(SOMEFIELD date) BEGIN IF a is NULL THEN return table( select cast(sdate as date) from quotes limit 10 ); ELSE return table( select cast(sdate as date) from quotes limit 10 ); END IF; END;-- ****** OR ******CREATE FUNCTION test(a text) RETURNS table(SOMEFIELD double) BEGIN declare table t(f double); select 0.0 into t; return t; END; -- ****** OR ******CREATE FUNCTION test(a text) RETURNS table(SOMEFIELD double) BEGIN declare table t(f double); set t = table (select 0.0); return t; END; When submit (not even execute) -> segfaultBug: https://www.monetdb.org/bugzilla/show_bug.cgi?id=3699Thanks,Vasili

1 0