- developers-list - monetdb.org

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

Re: developers-list Digest, Vol 7, Issue 20
by Meenesh sharma 30 Mar '13

30 Mar '13

sir/mam, I unable to read the contents therefore neither get my query's answer nor able to open it .... . . .. do send way to open it . On Fri, Mar 29, 2013 at 4: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. Re: how to speed up the loading of data into a table (Niels Nes) > 2. Re: how to speed up the loading of data into a table (Niels Nes) > 3. Re: how to speed up the loading of data into a table > (Stefan Manegold) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Thu, 28 Mar 2013 20:17:08 +0100 > From: Niels Nes <Niels.Nes(a)cwi.nl> > To: "Communication channel for developers of the MonetDB suite." > <developers-list(a)monetdb.org> > Subject: Re: how to speed up the loading of data into a table > Message-ID: <20130328191708.GB13470(a)niels.cwi.nl> > Content-Type: text/plain; charset="utf-8" > > On Thu, Mar 28, 2013 at 06:41:08PM +0000, Bouslah Ahmed wrote: > > 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? > typo ? > > Niels > > > > cordialy. > > > _______________________________________________ > > developers-list mailing list > > developers-list(a)monetdb.org > > http://mail.monetdb.org/mailman/listinfo/developers-list > > > -- > Niels Nes, Centrum Wiskunde & Informatica (CWI) > Science Park 123, 1098 XG Amsterdam, The Netherlands > room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl > url: http://www.cwi.nl/~niels e-mail: Niels.Nes(a)cwi.nl >

1 0

Re: How would I add a new directory to /monetdb5/extras/
by Stefan Manegold 28 Mar '13

28 Mar '13

It's a shared library that will only be loaded once required at run time. Just say yes when gab asks you if the breakpoint should only be set once the library/code is loaded. -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | ----- Reply message ----- From: "Chi-Young Ku" <chi(a)querymetrica.com> To: "Communication channel for developers of the MonetDB suite." <developers-list(a)monetdb.org> Subject: How would I add a new directory to /monetdb5/extras/ Date: Wed, Mar 27, 2013 19:08 Hi Babis, Thanks a lot for your help! I am able to get the foo directory compiled and built lib_foo.la. But, when I attatch GDB to the mserver5 process and try to set a breakpoint in foo.test(), I got an error saying foo.test() is not loaded. Have I missed anything? Chi ________________________________ From: Charalampos Nikolaou <charnik(a)di.uoa.gr> To: Communication channel for developers of the MonetDB suite. <developers-list(a)monetdb.org> Sent: Thursday, March 21, 2013 3:04 PM Subject: Re: How would I add a new directory to /monetdb5/extras/ Hi, you have to edit monetdb5/extras/Makefile.ag appending to variable SUBDIRS the name of the directory you want to add. For example, if you want to add directory "foo", given that the value of SUBDIRS was HAVE_RAPTOR?rdf HAVE_SPHINXCLIENT?sphinx HAVE_JAQL?jaql mal_optimizer_template the new value for SUBDIRS should be HAVE_RAPTOR?rdf HAVE_SPHINXCLIENT?sphinx HAVE_JAQL?jaql mal_optimizer_template foo Of course, this way you should run de-bootstrap and bootstrap again. Notice, that you have to specify also another Makefile.ag in monetdb5/extras/foo for taking care of the compilation of your code. However, I don't see any connection of your question to the message you replied to. Babis On Thu, Mar 21, 2013 at 7:35 PM, Chi-Young Ku <chi(a)querymetrica.com> wrote: > Hi, > > I would like to add a new sub-directory to /monetdb5/extras/ so that: > > 1. the configure process generates Makefiles for it and > > 2. it gets built when "make" is invoke in the top source directory. > > Thanks in advance. > > Chi > > > ________________________________ > From: Stephen P. Morgan <stephen_p_morgan(a)sbcglobal.net> > To: developers-list(a)monetdb.org > Sent: Thursday, March 21, 2013 12:06 PM > Subject: Question in re remote.exec() > > I have a question about remote.exec(). Let's say I have a user function, > s1_1 that takes a BAT as a parameter and returns a BAT. Its signature might > be: > > function user.s1_1(in:bat[:oid,:int]):bat[:oid,:int]; > > How can I call s1_1 using remote.exec to pass in a BAT and to retrieve the > result? I want to do something like > > X_2 := remote.exec(conn, "user", "s1_1", X_1); > > where X_1 and X_2 are both :bat[:oid,:int]. But that doesn't seem to work. > > Thanks, > > Steve Morgan > > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/developers-list > > > > _______________________________________________ > developers-list mailing list > developers-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/developers-list > _______________________________________________ developers-list mailing list developers-list(a)monetdb.org http://mail.monetdb.org/mailman/listinfo/developers-list

2 1

Re: Question about : LOAD DATA
by Stefan Manegold 27 Mar '13

27 Mar '13

Please see my answer I sent to your identical question yesterday. Stefan -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) | ----- Reply message ----- From: "Bouslah Ahmed" <a.bouslah(a)yahoo.fr> To: "developers-list(a)monetdb.org" <developers-list(a)monetdb.org> Subject: Question about : LOAD DATA Date: Wed, Mar 27, 2013 19:44 Good afternoon, 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? cordialy.

1 0

Question about : LOAD DATA
by Bouslah Ahmed 27 Mar '13

27 Mar '13

Good afternoon, 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? cordialy.

1 0