March 2014 - 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

Cycling through cursor in a procedure
by Radovan Bičiště 01 Apr '14

01 Apr '14

Hello, Please is there a flow control syntax for cycling through rows in a cursor in a procedure? I can not find any other solution to how to select highest numbers from a table which total falls under certain threshold. :( I have a function that returns sorted rows and can be used as a subquery and I did not get further ... Thank you, Radovan

4 5

Help, took 18 hours to COPY 113 million rows
by Bryan Senseman 28 Mar '14

28 Mar '14

Anybody have any insight into why the Windows performance is so poor? I am trying to restore a database (55GB total) and it took 18 hours to insert into my first big table. The CPU and Disk was less than 25% the entire time; with complete periods of zero activity. Attached is a screen show of the moderate cpu 28% and minor disk and the disk is **only** reading the dump file by mclient. -- ------------------------------ This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.

1 0

Restore/Load just hangs for hours (Windows Jan2014)
by Bryan Senseman 27 Mar '14

27 Mar '14

For about 3 hours I saw cyclical activity on memory and disk when loading the 55GB dump file (created on Linux via \D), however for the last 12 hours it has just sat there doing nothing. No CPU activity, no disk; this happened last time and I believe after 17 hours of "nothing" it popped up with a series of "operation completed" messages, what is it doing? -- ------------------------------ This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.

2 3

MonetDB on Windows keeps crashing
by Bryan Senseman 26 Mar '14

26 Mar '14

MonetDB (Feb2013SP5 & Jan2014) keep crashing on Windows Server 2008. Multiple times per week, we find the MonetDB process has crashed and needs to be restarted. Is there a log file somewhere that we can see that might give us insight into why it fails? -- ------------------------------ This transmission is confidential and intended solely for the use of the recipient named above. It may contain confidential, proprietary, or legally privileged information. If you are not the intended recipient, you are hereby notified that any unauthorized review, use, disclosure or distribution is strictly prohibited. If you have received this transmission in error, please contact the sender by reply e-mail and delete the original transmission and all copies from your system.

3 3

Extending physical memory via memory cache
by Calum Miller 26 Mar '14

26 Mar '14

Good Morning, Is it possible to extend the amount of physical memory available to monetdb via Memcached/Hazelcast? Thanks Calum Miller Millersoft

2 1

JDBC - how to set autocommit in url as on option
by Radovan Bičiště 21 Mar '14

21 Mar '14

Hello, We are using the JDBC driver from KETTLE (http://kettle.pentaho.com) tool. I could not find an option how to tell the driver that my connections are autocommit. I tried to add option autocommit=true. The tool added the opton at the end of the JDBC URL as follows jdbc:monetdb://172.26.123.14:50000/zkdev1;autocommit=true . But it failed with error that it could not find database "zkdev1;autocommit=true". Thank you for your help. Radovan

3 2

How to execute a MAL function in a monetdb database ?
by Leon-Constantin Fopa 17 Mar '14

17 Mar '14

I'm reading the MonetDB Internal Description because I'm interested to implement a special procedure direct in the MonetDB Algebra Language (MAL) instead of SQL-frontend (I hope to gain more performance by doing so). Here is a sample MAL code provide in the MonetDB documentation function sample(nme:str, val:any_1):bit; c := 2 * 3; b := bbp.bind(nme); #find a BAT h := algebra.select(b,val,val); t := aggr.count(h); x := io.print(t); y := io.print(val); end sample; My question is how to execute such a MAL code upon one of my existing database ? Thans for any replay

2 1

Copy table between monet instances using COPY BINARY ...
by Radovan Bičiště 17 Mar '14

17 Mar '14

Hello, I read the following recipe https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/BinaryBulkLoad . Please is there a command or a binary that does the dump part "Each attachment file is produced by a program that writes the binary image of the BAT directly, ..." ? (mclient --format=raw?) We are on "MonetDB Database Server v1.7 (Feb2013-SP6)". Thank you for your help. Radovan

2 1

COPY INTO table specify columns
by Wei Zhuo 17 Mar '14

17 Mar '14

Hi, Couldn't find any info/doc if a list of column names, and order of columns, can be specified when using COPY INTO command. If not possible, is this something relatively easy to implement? Thanks!

2 1