- developers-list - monetdb.org

Re: MonetDB: DVframework - For 64-bit integers we need to use type l...
by Ying Zhang 06 May '13

06 May '13

Stefan, FYI. Your fixes work. DVframework now also compiles on Lion :) Thanks! Jennie On May 06, 2013, at 19:22, Stefan Manegold wrote: > Changeset: 32b9bc615b3e for MonetDB > URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=32b9bc615b3e > Modified Files: > sql/backends/monet5/vaults/mseed.c > Branch: DVframework > Log Message: > > For 64-bit integers we need to use type lng, not type long. > MSRecord.samplecnt is defined as int64_t, i.e., a 64-bit integer; > hence, in MonetDB, we use type lng, not type long. > > PLEASE NOTE: > Ceterum censeo type long MUST NOT be used as it is everything but portable; > for instance, on our beloved Windows platforms, long is always 32-bit, > even on 64-bit systems. > > > diffs (30 lines): > > diff --git a/sql/backends/monet5/vaults/mseed.c b/sql/backends/monet5/vaults/mseed.c > --- a/sql/backends/monet5/vaults/mseed.c > +++ b/sql/backends/monet5/vaults/mseed.c > @@ -116,7 +116,7 @@ str SQLstatementIntern(Client c, str *ex > > #define QRYinsertI "INSERT INTO mseedCatalog(mseed, seqno, dataquality, network, \ > station, location, channel, starttime , samplerate, sampleindex, samplecnt, sampletype, minval,maxval) \ > - VALUES(%d, %d,'%c','%s', '%s','%s','%s','%s',%f,%d,%d,'%s',%d,%d);" > + VALUES(%d, %d,'%c','%s', '%s','%s','%s','%s',%f,%d,"LLFMT",'%s',%d,%d);" > > str > MseedImport(Client cntxt, MalBlkPtr mb, MalStkPtr stk, InstrPtr pci) > @@ -174,7 +174,7 @@ MseedImport(Client cntxt, MalBlkPtr mb, > } > t= MS_HPTIME2EPOCH(msr->starttime); > tm = gmtime(&t); > - snprintf(starttime,BUFSIZ,"%d-%02d-%02d %02d:%02d:%02d.%06ld", tm->tm_year +(tm->tm_year > 80?1900:2000), tm->tm_mon+1,tm->tm_mday, tm->tm_hour, tm->tm_min,tm->tm_sec, msr->starttime % HPTMODULUS); > + snprintf(starttime,BUFSIZ,"%d-%02d-%02d %02d:%02d:%02d.%06d", tm->tm_year +(tm->tm_year > 80?1900:2000), tm->tm_mon+1,tm->tm_mday, tm->tm_hour, tm->tm_min,tm->tm_sec, (int) (msr->starttime % HPTMODULUS)); > /* collect the statistics */ > switch(msr->sampletype){ > case 'i': > @@ -185,7 +185,7 @@ MseedImport(Client cntxt, MalBlkPtr mb, > if ( imax < ((int*) msr->datasamples)[j]) imax = ((int*) msr->datasamples)[j]; > } > snprintf(buf,BUFSIZ,QRYinsertI, *vid, msr->sequence_number,msr->dataquality,msr->network, msr->station, msr->location, msr->channel, > - starttime,msr->samprate, sampleindex,msr->samplecnt,"int",imin,imax); > + starttime,msr->samprate, sampleindex,(lng)msr->samplecnt,"int",imin,imax); > break; > case 'a': case 'f': case 'd': > default: > _______________________________________________ > checkin-list mailing list > checkin-list(a)monetdb.org > http://mail.monetdb.org/mailman/listinfo/checkin-list

1 0

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

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