February 2009 - users-list

[MonetDB-users] Proofreading your professional documents
by Richard Hounslow 24 Feb '24

24 Feb '24

Dear Professor/Lecturer Please excuse us for contacting you directly. We are offering an efficient service to help you ensure your academic and professional work is written in perfect English. We will check the grammar and style of your work and return it to you to meet your requirements and deadlines. Proof-Reading-Service.com can provide you with a professional proofreading service at a very reasonable rate. All our proofreaders are highly qualified native English speakers. Many work as leading academics in their fields and all have extensive experience of proofreading to the highest standards. If you are interested in our service, please take a look at our website: www.proof-reading-service.com All you have to do is send us your document as a word attachment with the deadline and we will guarantee delivery of a perfectly written document to give you complete confidence when you submit your work. The fee is worked out on a flat rate (£6.95 per thousand words or 0.695 pence per word), so you know exactly how much the proofreading will cost in advance. Once we have received your document(s) we will confirm the word count, the price and the deadline. If you have not heard from us within 2 hours during normal business hours after you have sent your work please resend it from a different email account or send the file to proofreadings(a)gmail.com. We look forward to hearing from you! Yours faithfully Proof-Reading-Service.com

2 2

[MonetDB-users] Kettle and MonetDB
by denvro 09 Mar '09

09 Mar '09

Hello, I have just installed Kettle 3.1 on my Archlinux machine. I wanted to use it with MonetDB but when i try to create a JDBC connection i get the following message: Error connecting to database [MonetDB] : org.pentaho.di.core.exception.KettleDatabaseException: Error occured while trying to connect to the database Error connecting to database: (using class nl.cwi.monetdb.jdbc.MonetDriver) Server challenge string unusable! Challenge contains too few tokens: !an internal error has occurred, please try again later I have merovingian running in the back and created a database "pentaho". See status below: bash-3.2# monetdb status -l pentaho pentaho: location: /usr/local/MonetDB/var/MonetDB5/dbfarm/pentaho database name: pentaho state: running locked: no scenarios: mal sql msql connections: mapi:monetdb://myhost:50001/ start count: 3 stop count: 2 crash count: 0 current uptime: 51m 10s average uptime: 13m 12s maximum uptime: 14m 42s minimum uptime: 11m 41s last crash: (unknown) last start: 2009-02-21 13:03:00 average of crashes in the last start attempt: 0 average of crashes in the last 10 start attempts: 0.00 average of crashes in the last 30 start attempts: 0.00 Can anybody help me with this. I already use the lates .jar (monetdb-1.9-jdbc). Kind Regards, Dennis -- View this message in context: http://www.nabble.com/Kettle-and-MonetDB-tp22141036p22141036.html Sent from the monetdb-users mailing list archive at Nabble.com.

2 3

[MonetDB-users] too deep recursion
by Lazaros Koromilas 02 Mar '09

02 Mar '09

Hi all, We are trying to annotate some XML data with MonetDB/XQuery. For this I run some big queries, that contain unions of many Xpath expressions (say 100). I get the following error: ERROR = !fatal error: aborted too deep recursion Tried to use the option declare option pf:recursion-depth "<number>"; I see no difference in bahaviour. I also call mclient with -G, though I don't know if it's needed. MonetDB Server is v4.26.2 and default back-end is 'algebra'. Any help with this? Thank you, Lazaros. -- http://www.ics.forth.gr/~koromil

3 4

[MonetDB-users] SUM of NULLs is 0?
by kelas 01 Mar '09

01 Mar '09

Dear MonetDB-users, a complete newbie to MonetDB, I can't really tell whether it is a bug, feature or I'm just getting it all wrong. A script below illustrates some weird NULL handling behaviour found in Nov2008-SP2: -- years under audit CREATE TABLE BUDGET_PERIOD (BP smallint NOT NULL); INSERT INTO BUDGET_PERIOD VALUES (1998); INSERT INTO BUDGET_PERIOD VALUES (1999); INSERT INTO BUDGET_PERIOD VALUES (2000); INSERT INTO BUDGET_PERIOD VALUES (2001); INSERT INTO BUDGET_PERIOD VALUES (2002); INSERT INTO BUDGET_PERIOD VALUES (2003); INSERT INTO BUDGET_PERIOD VALUES (2004); INSERT INTO BUDGET_PERIOD VALUES (2005); -- annual expenditure data CREATE TABLE EXPENDITURE (BP smallint NOT NULL, AMOUNT DECIMAL(15,2)); INSERT INTO EXPENDITURE VALUES (1999, 0.00); INSERT INTO EXPENDITURE VALUES (2000, 1.00); INSERT INTO EXPENDITURE VALUES (2001, 2.00); INSERT INTO EXPENDITURE VALUES (2002, 3.00); INSERT INTO EXPENDITURE VALUES (2003, 4.00); INSERT INTO EXPENDITURE VALUES (2004, NULL); -- calculate past years expenditure as of year: expected to be NULL for 1998, returns 0 SELECT A.BP, SUM( B.AMOUNT ) AS TOTAL_EXPD_ASOF FROM BUDGET_PERIOD A LEFT JOIN EXPENDITURE B ON (A.BP >= B.BP) GROUP BY A.BP ORDER BY A.BP -- same as above using CASE: returns all nulls (?!) SELECT A.BP, SUM( CASE WHEN A.BP >= B.BP THEN B.AMOUNT ELSE NULL END ) FROM BUDGET_PERIOD A, EXPENDITURE B GROUP BY A.BP go Regards, Vladimir

2 1

[MonetDB-users] [Fwd: Re: monetdb, xquery and perl]
by Martin Kersten 01 Mar '09

01 Mar '09

-------- Original Message -------- Subject: Re: monetdb, xquery and perl Date: Fri, 27 Feb 2009 10:35:15 +0100 From: francois guérin <replonk(a)gmail.com> To: Martin.Kersten(a)cwi.nl References: <31b3364e0902230836l140c9d0cs932937c392e8e9d(a)mail.gmail.com> <49A2EBEC.4050306(a)cwi.nl> ok! I'll then try the xrpc requests... is there a way to delete a collection in the database? (deleting documents one by one in a given collection is quite fastidious) and a way to delete a database created by the command Mserver --dbname=<...> ? (the only way i found was to physically delete directories with that same name) Thanks, francois. 2009/2/23 Martin Kersten <Martin.Kersten(a)cwi.nl>: > francois guérin wrote: >> >> Hi, >> I am about to develop an app using monetdb and its xquery part. >> My app will essentially be made of perl code. >> But it seems that perl is only used in monetdb's sql part, isn't? like >> using sql statements to access arrays and rows, but there's no way to >> access xml collections. >> >> Am i right or haven't i read enough of monetdb's documentation? > > You are right. The PHP, Perl, JDBC application interfacing to > the XML/XQuery part is less developed. > > regards, Martin >> >> Thanks a lot, >> >> francois. > >

2 1

[MonetDB-users] [Fwd: Re: Monet DB for RDF databases, BLOB]
by Martin Kersten 26 Feb '09

26 Feb '09

1 0

[MonetDB-users] Set the user of MonetDB in Windows
by Xiaofang Tao 23 Feb '09

23 Feb '09

Hello, I intend to know how can I specify the user of one database on the Monet. Hoping for your reply. Thank you very much. TaoXiaofang

2 1

[MonetDB-users] external functions
by dariuszs 21 Feb '09

21 Feb '09

Hi, Does anybody have an example of how to call external functions written in C? Thank you. Dariusz.

2 1

[MonetDB-users] Corrupt DB - missing bat files
by David Svenson 19 Feb '09

19 Feb '09

Hi, When importing date with 'COPY INTO' I reached a database corruption state. When I open the server, it comes up fine, but immediately when I start a client the server crashes with this message: # Listening for connection requests on mapi:abacusdb://127.0.0.1:50000/ # AbacusDB/SQL module v2.27.0 loaded >!ERROR: GDKload: cannot open: name=01\106, ext=head !OS: The system cannot find the path specified. !ERROR: GDKload: failed name=01\106, ext=head The bat files for 01\106 that are mentioned in the error message are missing from the dbfarm. Does the fact that they are supposed to be in folder 01 mean that these are system tables? Can I recover from this state, or has my current database become unrecoverably corrupt? -- View this message in context: http://www.nabble.com/Corrupt-DB---missing-bat-files-tp22096097p22096097.ht… Sent from the monetdb-users mailing list archive at Nabble.com.

1 0

[MonetDB-users] Please, HELP me!
by Xiaofang Tao 18 Feb '09

18 Feb '09

Hello, my friends： I have just installed the latest version of MonetDB5 (SQL) on windows, 32bit system. When I start the client (start-programs-MonetDB5-MonetDB SQL Client), after I start the server (start-programs-MonetDB5-MonetDB SQL Server), the client window prompted start with sql, and I can not use the command like -d. -f, -H, -u and so on, moreover, I can not specify the user or the schema. If I want to use these commands and to specify the user and the schema, what I should do. Hoping for your reply! Best regards. Tao Xiaofang

1 0