August 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

MonetDB Cluster Management
by Ali Salem 05 Sep '14

05 Sep '14

Hello all, I followed the tutorial on https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/ClusterManagement but I still can't get it to work. I followed all instructions, but *monetdb discover *only returns instance(s) running on the same machine, but not others on the network. I am using three machines running debian, with monetdb installed and configured according to the link above. What am I missing? Your assistance is highly appreciated.

2 4

Available binary functions
by Dennis Pallett 02 Sep '14

02 Sep '14

Hi all, I'm just wondering what kind of binary functions MonetDB comes with standard? I'm specifically looking for a function to convert a smallint/int/bigint into a byte array (either big or little endian), concat several byte arrays into a single byte array and encode a byte array as a hex string. Do any such functions exist or do I need to write them myself in C? Best regards, Dennis Pallett

2 2

Costly bat.new/bat.append not optimized out
by Frédéric Jolliton 28 Aug '14

28 Aug '14

Hi, Unless I'm missing something, I do not understand why this apparent pattern is not easily optimized out: X_3:bat[:oid,:lng] =<tmp_321264>[0] := bat.new(nil:oid,nil:lng); .. # X_3 is never used before this line. X_19=<tmp_331015>[23068647] := <some computation> X_20=<tmp_321264>[23068647] := bat.append(X_3=<tmp_321264>:bat[:oid,:lng][23068647], X_19=<tmp_331015>[23068647],true); # X_3 is never used after this line. An empty BAT is created for the sole purpose of appending a BAT with millions of rows, discarding the original one.. instead of just using it! This account for up to 30% of the time spent for some SQL queries! Like this one: SELECT name, avg(value) FROM some_view GROUP BY name LIMIT 10; I tried to manually remove these extra operation, and I got the exact same result, in less time. (I took the output of EXPLAIN, removed the lines in question, and added a bit of type information for the function to compile, before playing it in mclient -l mal.) Regarding the setup, for our tests, we have 3 tables (say, a, b and c) of 11M rows each, then a view declared as: CREATE VIEW some_view AS (SELECT * FROM a UNION ALL SELECT * FROM b UNION ALL SELECT * FROM c); I've tested it with v11.17.21 and v11.19.0, with the "default" optimizer. My question: is this extra operation required, or could it be optimized in MonetDB? -- Frédéric Jolliton SecurActive

2 7

ODBC driver and config on the Mac?
by Robert Kosara 19 Aug '14

19 Aug '14

Hello, I’ve been trying to connect to MonetDB via ODBC on Mac OS X, without luck. I’m seeing the ODBC drivers in /usr/local/monetdb/lib/, but I’m confused that they are .so files and not .dylib. It looks like all the others are .dylib, and as far as I know that’s required so they can be loaded dynamically. I’ve tried using the .so files in the ODBC manager, but that has only made it crash. Has anybody used MonetDB with ODBC on the Mac? Can you perhaps show me your configuration? Thanks, Robert

2 1

Table is not unique, corrupt catalog?
by Ali Salem 11 Aug '14

11 Aug '14

Hello all, Last night I imported 500M records into my fact table, it took around 19 hours, but it worked fine. I created my indexes afterwards with no issues as well. However, when I tried to access the rest of the tables in my database, I received the following error: table table_name is not unique, corrupt catalog? Any idea why this happened and how to fix it? Thank you.

1 1

MonetDB partition by day
by Ali Salem 08 Aug '14

08 Aug '14

Hello all, I know MonetDB has window functions, but can I partition a table by day? If you can direct me to a link with examples, I'd appreciate it. Thanks

1 0

MEDIAN(double) not found
by Radovan Bičiště 08 Aug '14

08 Aug '14

Hello, We use MonetDB Jan2014-SP2. When I try MEDIAN function it simply says: MEDIAN: no such operator 'median(double)' [SQL State=22000] Am I missing something? I tried to execute section of 39_analytics.sql containing the MEDIAN function. It says MEDIAN function is already there. Thank you for any tips. Radovan Test Case: I took the sql from bug 2454: select median(id) from sys.tables; result: An error occurred when executing the SQL command: select median(id) from sys.tables MEDIAN: no such operator 'median(int)' [SQL State=22000] Execution time: 0.03s 1 statement failed.

2 2

Connection Reset(mserver still alive?)
by Ali Salem 06 Aug '14

06 Aug '14

Hello, I have recently started using MonetDB for a BI project, and it's doing pretty well. However, I receive a connection reset error each time I run an ETL process (I use Pentaho PDI) to populate my dimensional schema. This error is reported by the MonetDB JDBC driver *Connection reset(mserver still alive?)* This usually happens after a random amount of time, 30 min, 45 min, 1 hour, etc. Any pointers related to this would be very helpful. Specs ------- Ubuntu 12.04 8 GB Ram 500 GB Space Pentaho PDI (community edition) Monetdb5 (installed using apt-get) Thank you.

4 6

SIGSEGV during log flush
by Richard Hughes 01 Aug '14

01 Aug '14

Hello, Can I persuade a developer to help me out with bug 3422 [https://www.monetdb.org/bugzilla/show_bug.cgi?id=3422#c4]? I'm amassing an unhealthy collection of core dumps now (about one a day), and the latest is from Jan2014SP3 which I upgraded to last night. FWIW I'm no longer sure that I am looking at the same SIGSEGV as the one that the original bug reporter was talking about - of course I can create a new Bugzilla entry if it helps. This is our staging platform so I have the ability to run all sorts of custom builds or anything else that will help debug it, I'm just not sure where to start looking; I'd really appreciate some hints. Thanks for your help, Richard.

1 0