Dear all,
I want to import *.csv into MonetDB,what interface do i will use？
Best regards
--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http:
Dear everyone,
Recently,i am testing the performance of MonetDB. But I want to know the
time of execution one sql. I type \t on CLI. and then it returns a
execution time. But I found that the time include the print resultset time.I
just only want to know the time of execution ,not include the p
Thank you，Stefan Manegold.I will try. I want to go to CWI to study database
.CWI is a very excellent research institutions.
Best regards!
2010/7/15 Stefan Manegold
> On Thu, Jul 15, 2010 at 04:45:25PM +0800, kun ren wrote:
> > Dear everyone,
> >Recently,i am testing the
I have try the redirecting ,but it also have more time,and contain the
write file time.I just only want to know the time of actual execution
time.what do i do?
In monetdb homepape,i see your benchmarks,and I want to know how did you
test the time?
在 2010年7月15日 下午9:30，kun ren 写道：
> Thank
Really？is *Jun2010* release？Thanks
Best regards
2010/7/16 Fabian Groffen
> On 16-07-2010 10:44:40 +0800, kun ren wrote:
> > I have try the redirecting ,but it also have more time,and contain the
> > write file time.I just only want to know the time of actual execution
> &
Dear all,
Recently,I use TPC-H test the Monetdb, On windows ,so I use "copy
,, records,,,into,,from" to load data to Monetdb,when the size of the file
is about 700M,It is OK.But when the size is 1.4G,the Monetdb server is auto
stop when loading. But when I am in Linux, it is no problem. So
Dear everyone,
Some days ago,I debug monetdb on linux ,use eclipse + gdb, but now I
want to debug and compile the monetdb on windows, please tell me how would i
will do to compile and debug the monetdb.
Best regards!
--
Dear all,
hello,all, I download the windows installer of monetdb,and install,and
then start MonetDB server, my computer has 4 cpus.and with 32bit windows xp
,but the MonetDB server only start one thread.when I run MonetDB in Linux
with 2 cpus, it start 2 threads. so why? why I am in Windows xp w
Thanks, professer Stefan.I will do my exprierment on linux.
2010/7/29 Stefan Manegold
> Hi Kun Ren,
>
> we do not know of a simple way (e.g., system call) to find out the number
> of
> CPU cores on a Windows system, hence, we set the default number of threads
> in the M
Dear everyone,
Recently,I am intersting in MAL optimize，and have read the manual of the
MAL optimize, but it is so long, Possible if we want to use mal optimize ,we
must degignation the optimize consideration, such as alias removal,
constant expression,join path optimizer;And then I dedug the
is used for optimizing?
2010/8/11 Fabian Groffen
> On 11-08-2010 15:25:15 +0800, kun ren wrote:
> >Recently,I am intersting in MAL optimize，and have read the manual of
> the
> > MAL optimize, but it is so long, Possible if we want to use mal optimize
> ,we
> > must
am create it) that does
> explicitly call a MAL optimizer, that MAL optimizer is indeed used to
> optimize the MAL code according to its very purpose.
>
> Stefan
>
> On Wed, Aug 11, 2010 at 03:49:47PM +0800, kun ren wrote:
> > It is only used by SQL? and how to designation the optimiser
for column-oriented?
Best regards!
2010/8/11 Stefan Manegold
> On Wed, Aug 11, 2010 at 04:23:42PM +0800, kun ren wrote:
> > I read sql_optimizer setting in monetdb5.conf ,and default setting is:
> > sql_optimizer=default_pipe
> >
> default_pipe=inline,remap,evaluate,cost
f all MAL optimizers, is very unique to MonetDB5/SQL and MAL.
>
> Stefan
>
> On Wed, Aug 11, 2010 at 04:38:01PM +0800, kun ren wrote:
> > Thanks，professor Stefan Manegold,when I use explain,I get the optimizer
> MAL
> > plan.
> > I have another question, so we know
whole,
all MAL optimizers is unque for MonetDB. Do I understand right?
在 2010年8月11日 下午5:21，kun ren 写道：
> Thanks very much, you means the ideas and intension of MAL optimizers
> contain three parts: 1. programming language/compiler optimization 2.
> databose query optimization 3. some opt
dear all，
Recently when I am reading MAL optimizer manual of MonetDB.and don't
know the Merge Table optimizer,A merge association table (MAT). (1)How it
perform optimize the MAL?
(2) for this example,
before optimize,
m0:= bat.new(:oid,:int);
m1:= bat.new(:oid,:int);
m2:= bat.new(:oid,:int);
b
Dear all,
My test application want to implement two application interface over
MonetDB , one is loading *.csv file to MonetDB, to implement this interface
,I use MonetDB's JDBC and "copy from" command to implement it. and another
interface is select from one bat using select conditions,
Dear all,
Recently,I am using MAL,using mclient -l mal command, If I use sql, I
write a SQL: select * from t1; while t1 has two column c1 and c2,type is
int. I want to ask what the corresponding MAL of this sql, if I us mclient
-l mal ,what mal will I will use to implement the select * from t1
1PM +0800, kun ren wrote:
> > Dear all,
> > Recently,I am using MAL,using mclient -l mal command, If I use
> > sql, I write a SQL: select * from t1; while t1 has two column c1 and
> > c2,type is int. I want to ask what the corresponding MAL of this sql,
> > if I u
Thanks !
But when I use mclient -lmsql, but it has a error, the error is :language
option needs to be one of sql, mil, mal, or xquery?
Best regards!
2010/8/18 Fabian Groffen
> On 18-08-2010 15:21:30 +0800, kun ren wrote:
> > Yes,I know expain. I mean I use MAL interface, write MAL i
Yes, when I run successfully! But why I must running sql.init() and then can
run mal code?
Best regards!
2010/8/18 Niels Nes
> On Wed, Aug 18, 2010 at 03:53:49PM +0800, kun ren wrote:
> > Thanks !
> > But when I use mclient -lmsql, but it has a error, the error is
> > :lan
Dear all,
I use MAL interface to manipulate the BAT data, I use sql.bind(,,0) to get a
BAT, and use io.print() to print the BAT content, but when I use bat.insert
to insert one bun to the bat,but after the bat.insert(), I run io.print() to
print the BAT,but the bat content is not changed，I use sql.
dear all
recently,I want to run mapi examples from
/Monetdb-client/clients/src/examples/C/, it contains sample0.c ,sample1.c
and so on. I read the Application Programming Interfaces of the Monetdb
manual, and I use: gcc sample0.c 'monetdb-clients-config --cflags --lib'
-lMapi -o sample0 to complie
sample0.c:104: warning: initialization makes pointer from integer without a
cast
I don't know how to solve it?
Best regards
2010/8/19 Stefan Manegold
> On Thu, Aug 19, 2010 at 02:30:04PM +0800, kun ren wrote:
> > dear all
> > recently,I want to run mapi examples from
> &g
Thanks very much, professor Stefan. I just set /bin to the PATH, so
it is succeeful!
Best regards!
2010/8/19 Stefan Manegold
> On Thu, Aug 19, 2010 at 03:07:30PM +0800, kun ren wrote:
> > thank you, professor Stefan,
> > I use what your suggest command to complie the sample0.c
25 matches
Mail list logo
