April 2013 - developers-list

how to speed up the loading of data into a table
by Bouslah Ahmed 18 Jun '13

18 Jun '13

Good afternoon, I have 2 questions : - 1st question I have a csv file with 300000000 million lines. when I load it in a MonetDB table, it takes more than 16 hours, whereas in Oracle it only takes 15 minutes. Where is the problem? I use mclient as follows :? mclient -u user1 -d demo -ims -s " COPY 300000009 RECORDS INTO LINEORDER FROM STDIN USING DELIMITERS '|','\n'" - < D:\SSB\LINEORDER.tbl ?for information I use : MonetDB5 Windows Memory : 16 Go There are two constraints : primary key and foreign key on the table prior to loading data? 2nd question : how inner joins are made in MongoDB? cordialy.

3 4

Announcement: New Feb2013-SP2 Bugfix release of MonetDB suite
by Sjoerd Mullender 29 Apr '13

29 Apr '13

The MonetDB team at CWI/MonetDB BV is pleased to announce the Feb2013-SP2 bugfix release of the MonetDB suite of programs. More information about MonetDB can be found on our website at <http://www.monetdb.org/>. For details on this release, please see the release notes at <http://www.monetdb.org/Downloads/ReleaseNotes>. As usual, the download location is <http://dev.monetdb.org/downloads/>.

1 0

Fix to the typing issue in MAL generation
by Masood Mortazavi 22 Apr '13

22 Apr '13

Attached, please find a fix for the typing issue in MAL generation, reported in http://bugs.monetdb.org/show_bug.cgi?id=3252 The fix was produced on: Feb2013_SP1_release 47060:fc0c9b319d22 We have not done thorough, release testing of this fix but it appears correct, and we have used it successfully. Regards, Masood P.S. By the way, what's the proper way to report or submit minor fixes like this?

1 0

Help:How can i start MonetDB development quickly
by 高小猛 22 Apr '13

22 Apr '13

sir/mam, I am a newbie to MonetDB development . I have read some paper and user guide about MonetDB. And i download the sourse code and want to modify the code, especially the storage part, to test my idea. However, the project is too large to understand quickly. anyone can give me suggestion ? Whether are there documents or structure charts about the project that make newbie to understand quickly. thanks. Andy

2 3

Re: MonetDB: default - Cross-Compile JDBC connector to Java 1.5 and up
by Fabian Groffen 17 Apr '13

17 Apr '13

On 17-04-2013 14:39:48 +0200, Hannes Muehleisen wrote: > Changeset: c81ba7ca1e8c for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c81ba7ca1e8c > Modified Files: > java/build.xml > Branch: default > Log Message: > > Cross-Compile JDBC connector to Java 1.5 and up IMO this is wrong, please undo it. -- Fabian Groffen fabian(a)monetdb.org column-store pioneer http://www.monetdb.org/Home

1 0

Re: MonetDB: Feb2013 - add temporary to the non-reserved keywords
by Sjoerd Mullender 12 Apr '13

12 Apr '13

On 2013-04-12 21:35, Niels Nes wrote: > Changeset: 2d22867fb284 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=2d22867fb284 > Modified Files: > sql/server/sql_parser.y > Branch: Feb2013 > Log Message: > > add temporary to the non-reserved keywords > > > diffs (11 lines): > > diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y > --- a/sql/server/sql_parser.y > +++ b/sql/server/sql_parser.y > @@ -4721,6 +4721,7 @@ non_reserved_word: > | ACCORDING { $$ = sa_strdup(SA, "according"); } > | URI { $$ = sa_strdup(SA, "uri"); } > | FILTER { $$ = sa_strdup(SA, "filter"); } > +| TEMPORARY { $$ = sa_strdup(SA, "temporary"); } > ; > > name_commalist: > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/checkin-list > A Changelog message would not be amiss here. -- Sjoerd Mullender

1 0

Re: MonetDB: default - fixed problem unaligned avg/counts bats.
by Sjoerd Mullender 10 Apr '13

10 Apr '13

Was this the problem we discussed yesterday? If so, shouldn't this be on the Feb2013 branch? On 2013-04-10 11:00, Niels Nes wrote: > Changeset: 16f6734d1286 for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=16f6734d1286 > Modified Files: > monetdb5/optimizer/opt_mergetable.c > Branch: default > Log Message: > > fixed problem unaligned avg/counts bats. > > > diffs (28 lines): > > diff --git a/monetdb5/optimizer/opt_mergetable.c b/monetdb5/optimizer/opt_mergetable.c > --- a/monetdb5/optimizer/opt_mergetable.c > +++ b/monetdb5/optimizer/opt_mergetable.c > @@ -633,7 +633,7 @@ mat_aggr(MalBlkPtr mb, InstrPtr p, mat_t > pushInstruction(mb, u); > > /* Filter empty partitions */ > - if (getModuleId(p) == aggrRef) { > + if (getModuleId(p) == aggrRef && !isAvg) { > s = newInstruction(mb,ASSIGNsymbol); > setModuleId(s, algebraRef); > setFunctionId(s, selectNotNilRef); > @@ -710,6 +710,15 @@ mat_aggr(MalBlkPtr mb, InstrPtr p, mat_t > pushInstruction(mb, w); > > r = w; > + > + /* filter nils */ > + s = newInstruction(mb,ASSIGNsymbol); > + setModuleId(s, algebraRef); > + setFunctionId(s, selectNotNilRef); > + getArg(s,0) = newTmpVariable(mb, battp); > + s = pushArgument(mb, s, getArg(r,0)); > + pushInstruction(mb, s); > + r = s; > } > > s = newInstruction(mb,ASSIGNsymbol); > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/checkin-list > -- Sjoerd Mullender

1 0

Re: developers-list Digest, Vol 8, Issue 1
by Meenesh sharma 01 Apr '13

01 Apr '13

this is too much , am not getting where to read for answer especially for mine questions ... where where where ????????? do reply for god sake..... On Mon, Apr 1, 2013 at 3:30 PM, <developers-list-request(a)monetdb.org> wrote: > Send developers-list mailing list submissions to > developers-list(a)monetdb.org > > To subscribe or unsubscribe via the World Wide Web, visit > http://mail.monetdb.org/mailman/listinfo/developers-list > or, via email, send a message with subject or body 'help' to > developers-list-request(a)monetdb.org > > You can reach the person managing the list at > developers-list-owner(a)monetdb.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of developers-list digest..." > > Today's Topics: > > 1. Help:How can i start MonetDB development quickly (???) > > > ---------- Forwarded message ---------- > From: 高小猛 <xmgtih(a)gmail.com> > To: developers-list(a)monetdb.org > Cc: > Date: Mon, 1 Apr 2013 16:09:13 +0800 > Subject: Help:How can i start MonetDB development quickly > sir/mam, > I am a newbie to MonetDB development . I have read some paper and user > guide about MonetDB. And i download the sourse code and want to modify the > code, especially the storage part, to test my idea. However, the project > is too large to understand quickly. anyone can give me suggestion ? > Whether are there documents or structure charts about the project that > make newbie to understand quickly. thanks. > > > Andy > > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/developers-list > > -- " HAVE A NICE DAY"

3 2