October 2013 - users-list

Monetdb python error in connection
by Rose Beck 19 Oct '13

19 Oct '13

I am using python-monetdb 11.16.0.7. I created my database farm and database according to instructions given below (source: http://www.monetdb.org/Documentation/monetdbd) % monetdbd start /home/my-dbfarm % monetdb create my-first-db Then I tried to connect to the database using the below mentioned command in python(https://pypi.python.org/pypi/python-monetdb/). Upon doing so I am getting the below mentioned error: >import monetdb.sql >connection=monetdb.sql.connect(… [View More]

1 0

Re: nulls last
by Klaudiusz 18 Oct '13

18 Oct '13

On 18.10.2013 12:05, Hilario Fernandes wrote: > O made the same test in SP4 and the results were the same, sum(null) kept > returning 0 and no results for the case. My tests in SP5 were done with a > clean database with no data imported, so according to your tests i should > at least have the correct value for the sum... > > These are the queries i've done and what i believe would be the expected > results: > > create table test (number int, name varchar(50)); > &… [View More]

1 0

nulls last
by Hilario Fernandes 18 Oct '13

18 Oct '13

Hello, I'm trying to build a query with order by that puts nulls last always. I tryed to use the "NULLS LAST" expression but apparently it's not supported by monetdb. So i came up with something like this: select name, sum(number) from test group by name order by case when sum(number) is null then 1 else 0 end, sum(number) ASC Thing is, this works when the ordering column (number) is not aggretated, as soon as i throw the sum in there it returns no results. The sum of null values seems … [View More]

2 1

Announcement: New Feb2013-SP5 Bugfix release of MonetDB suite
by Hannes Mühleisen 16 Oct '13

16 Oct '13

The MonetDB team at CWI/MonetDB BV is pleased to announce the Feb2013-SP5 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/>. Feb 2013-SP5 bugfix release Client Package * ODBC: Implemented … [View More]

1 0

Fwd: Query execution time
by baraa Mohamad 13 Oct '13

13 Oct '13

>> Hello dear MontDB users, >> >> I have a question please, I just need to get the query execution time >> without showing the results of the query (for performance comparaison) . >> Something which corresponds to the "traceonly" in Oracle. that will be >> greate if I can see the query plan but for the moment the most important >> for me is to get the query execution time. >> >> for example: I want to know the query exection time of this … [View More]

4 16

Re: How to transfer monetdb database to another machine
by Rose Beck 13 Oct '13

13 Oct '13

Thanks a lot for helping. I am unable to figure as to where does * <dbfarm>/<dbname>* directory reside within ubuntu 12.04. Can you please help me with this. On Sun, Oct 13, 2013 at 6:06 PM, <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 … [View More]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: Query execution time (baraa Mohamad) > 2. Re: Query execution time (Martin Kersten) > 3. Re: How to transfer monetdb database to another machine > (Martin Kersten) > 4. Re: Query execution time (Martin Kersten) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Sun, 13 Oct 2013 12:31:35 +0200 > From: baraa Mohamad <bem85(a)hotmail.com> > To: Communication channel for MonetDB users <users-list(a)monetdb.org> > Cc: Communication channel for MonetDB users <users-list(a)monetdb.org> > Subject: Re: Query execution time > Message-ID: <BAY406-EAS1557A9804AABD08B94A7905A8190(a)phx.gbl> > Content-Type: text/plain; charset="utf-8" > > That's great! Thank you very much for your appreciated help. > > I just could't really understand the output of this command. > > This is my output: > Real: 1m23 > User: 0m24s > Sys: 0m2.3s > > I'm a little bit confused because when I execute the same query directly > without the time option i get 733,28ms. > > So i couldn't know what is the real execution time. > > > > > Le 13 oct. 2013 ? 11:29, "Martin Kersten" <Martin.Kersten(a)cwi.nl> a > ?crit : > > > > How about (time mclient -d db <inputfile >/dev/null) > > > >> On 10/13/13 11:24 AM, baraa Mohamad wrote: > >> Thank you for your answer. > >> But in general I would like to know how to get the query exexution time > >> without printing the results. It's for performance comparaison. I want > >> to evaluate MonetDB for my research and i'm working with large tables. > >> > >> Please any idea?? > >> > >> Greetings, > >> Baraa > >> > >> > >> > >> > >> Le 13 oct. 2013 ? 11:02, "Martin Kersten" <Martin.Kersten(a)cwi.nl > >> <mailto:Martin.Kersten@cwi.nl>> a ?crit : > >> > >>> Hi > >>> > >>> > >>>> On 10/13/13 10:55 AM, baraa Mohamad wrote: > >>>> > >>>>>> Hello dear MontDB users, > >>>>>> > >>>>>> I have a question please, I just need to get the query execution > time > >>>>>> without showing the results of the query (for performance > >>>>>> comparaison) . > >>>>>> Something which corresponds to the "traceonly" in Oracle. that will > be > >>>>>> greate if I can see the query plan but for the moment the most > >>>>>> important > >>>>>> for me is to get the query execution time. > >>>>>> > >>>>>> for example: I want to know the query exection time of this query > >>>>>> (select * from source where a>10) knowing that I have more than one > >>> This is not the ind of query you fire when you expect a large outcome. > >>> Better use SELECT COUNT(*).... > >>> > >>>>>> hundred million records which correspond to this predicate. > >>>>>> > >>>>>> Thank in advace for your appreciated help. > >>>>>> > >>>>>> Baraa > >>>> _______________________________________________ > >>>> users-list mailing list > >>>> users-list(a)monetdb.org <mailto:users-list@monetdb.org> > >>>> https://www.monetdb.org/mailman/listinfo/users-list > >>> _______________________________________________ > >>> users-list mailing list > >>> users-list(a)monetdb.org <mailto:users-list@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 > > _______________________________________________ > > users-list mailing list > > users-list(a)monetdb.org > > https://www.monetdb.org/mailman/listinfo/users-list > [View Less]

2 1

How to transfer monetdb database to another machine
by Rose Beck 13 Oct '13

13 Oct '13

I created monetdb database using the python library https://pypi.python.org/pypi/python-monetdb/11.16.0.7 on my ubuntu 12.04 lts server. Now I want to transfer this database to another ubuntu 12.04 lts server. However, I am unable to understand as to where(directory name) does monetdb create its database (within ubuntu 12.04) and what is the procedure which I must follow to transfer this database to another machine (so that i may query the database on another machine)?

2 1

Crashed DB - BBPextend: trying to extend BAT pool beyond the limit
by Pedro Salgueiro 08 Oct '13

08 Oct '13

Hi, We have a MonetDB instance which was working without problems and suddenly stopped working. The following error shows up in "merovingian.log" when the client(mclient) tries to connect to the database: 2013-10-07 10:35:27 ERR testbd[12111]: !FATAL: BBPextend: trying to extend > BAT pool beyond the limit (16384000) > 2013-10-07 10:35:27 ERR testbd[12111]: > 2013-10-07 10:35:27 MSG merovingian[12015]: database 'testbd' (12111) has > exited with exit status 1 > 2013-10-07 10:35:… [View More]

3 8

ORDER BY in sub-query
by Hadley Wickham 08 Oct '13

08 Oct '13

Currently, monetdb fails on this query: SELECT * FROM (SELECT * FROM "Batting" ORDER BY "playerID") with syntax error, unexpected ORDER, expecting INTERSECT or EXCEPT or UNION or ')' in: "select * from (select * (obviously that query isn't very useful, but it makes it harder to automatically generate sql) In case it matters, that query (with minor escaping variations) works in sqlite, postgres and mysql. Hadley -- Chief Scientist, RStudio http://had.co.nz/

5 17

Create database other then "demo" in windows 8
by Prashant Patel 07 Oct '13

07 Oct '13

Hi all, I am using MonetDB on my windows 8 platform every time open monetdb client and server , it automatically connects to "demo" database by default. I am very new to these technology I have searched but couldn't find how to create our own database in monetdb (other then "demo"). Can anyone tell me how to create database and connect that database in monetdb server and client. I know this is very dump question but help will be really appreciated. ( If i can get some … [View More]

2 2