- users-list - monetdb.org

SQLsetTrace assumes in-place append
by Roberto Cornacchia 14 Jun '17

14 Jun '17

Background: I'm working on a side-effect-free branch of MonetDB. No in-place operations allowed. With bat.append() already changed this way, everything seemed to work so far, except TRACE. Even TRACE SELECT 1 would fail. I looked at it and the reason is that SQLsetTrace assumed in-place appends, thus first adding new empty bats to resultset, then filling in those bats. Everywhere else this is not assumed. The return bat of append is always created and used, even if it is the same of the first operand. The diff in attachment makes it work for both branches and is in my opinion more correct and consistent with the rest of the code. Best, Roberto

1 0

Announcement: New Dec2016-SP5 Bugfix release of MonetDB suite
by Sjoerd Mullender 12 Jun '17

12 Jun '17

The MonetDB team at CWI/MonetDB BV is pleased to announce the Dec2016-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/>. Dec 2016-SP5 bugfix release Bug Fixes * 6290: Crash (and assertion failure) with a correlated subquery with NOT IN in the select-list * 6291: crash if executes a function with sample operator * 6294: Sqlitelogictest crash * 6296: Another sqllitelogictest crash :( * 6297: 7th sqllitelogictest crash :( * 6300: Protect against missing BATs (sqlsmith) * 6314: Lateral crash report (sqlsmith) * 6315: Exist operator on type bigint missing (sqlsmith) * 6316: Coalesc and limit error (sqlsmith) * 6317: Two-column integer aggregation extremely slow * 6318: Daemon crashes if .merovignian_properties for a database contains more than 42 entries * 6320: The daemon ignores all but the last entry in the .merovignian_properties file when spawning mserver5

1 0

How to use prepared statements within a function
by Luis Larios 08 Jun '17

08 Jun '17

Hi, We’d like to know if there is a way to create and execute prepared statements within an SQL function. In particular, once that we use: “prepare select * from table” How can I retrieve the prepared statement ID to use in an exec()? Thanks, Luis Ángel. The information transmitted, including any attachments, is intended only for the individual or entity to which it is addressed, and may contain confidential and/or privileged information. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by individuals or entities other than the intended recipient is prohibited, and all liability arising therefrom is disclaimed. If you have received this communication in error, please delete the information from any computer and notify the sender.

2 1

Cannot execute embedded R in MonetDB
by Luis Larios 25 May '17

25 May '17

Hi, We are having issues when executing embedded R in a MonetDB SQL function. We have compiled and configured MonetDB accordingly, so as to be able to run embedded R; however, the simple example in the documentation fails to execute. This is the function we have: create function rapi00() returns table( d int ) language R { return seq(1,10); }; Having just "seq(1,10)" doesn't make any difference either. When this function gets created, we don't get any error; however, when we do the following: select d from rapi00() as r where d > 5; we get the this error: Query failed: TypeException:user.s6_3[3]:'rapi.eval' undefined in: X_4:bat[:int] := rapi.eval(7fdb9830e210:ptr,"{\n\treturn seq(1,10);\n};":str); We don't know how to tackle this issue. We have followed the process from https://www.monetdb.org/content/embedded-r-monetdb. Do you have any suggestion to make this work? Thanks! Luis Ángel. The information transmitted, including any attachments, is intended only for the individual or entity to which it is addressed, and may contain confidential and/or privileged information. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by individuals or entities other than the intended recipient is prohibited, and all liability arising therefrom is disclaimed. If you have received this communication in error, please delete the information from any computer and notify the sender.

2 1

binary bulk loading improvements?
by Lynn Carol Johnson 22 May '17

22 May '17

Hello Stefan and developers – Has any more thought been given to performance issues on binary bulk loading of large tables? I’m hoping to hear the “steal” option will be available in an upcoming release. Thanks - Lynn

1 0

Distributed Join and Replica Tables
by Kelly Burkhart 11 May '17

11 May '17

Can someone describe how exactly replica tables are used to push joins to worker nodes? Assume a master node and two worker nodes. I assume my reference table would go on my master node, and on my worker nodes I would have my large data table and replicas of the reference tables from the master node. Is that the general strategy? Thanks, -K

4 6

RE: Queries regarding embedded python
by Ganesh 08 May '17

08 May '17

Hi there, hope you are doing good. We were trying to implement Monetdb/python i.e. embedded python and tried the following code but its giving an error. (We have tried it on Linux) CREATE FUNCTION python_times_two(i INTEGER) RETURNS INTEGER LANGUAGE PYTHON { return i * 2 }; CREATE TABLE integers(i INTEGER); INSERT INTO integers VALUES (1), (2), (3), (4), (5); SELECT python_times_two(i) AS result FROM integers; Error: TypeException:user.s12_1[10]:'pyapi.eval' undefined in: X_18:int := pyapi.eval(0x7f051006a340:ptr,"{\n return i * 2\n};":str,X_17:int); Please help us on what should be done in order to code to work. Also need clarification on following points: 1. Does embedded R or embedded python work on windows? 2. Does it take data in memory when we use machine learning with Numpy and Scikitlearn? Awaiting for your response. Warm Regards, Ganesh Anbhule Data Scientist

2 1

Retrieving all schemata for a user
by Luis Larios 07 May '17

07 May '17

Hi, I wonder if anyone knows how I can retrieve all schemata on which a user has been granted permissions/authorization. I have checked most of the hinting tables I get from querying >> select id, name, schema_id, query from sys.tables where system = true; but I have had no luck with that. I only get the default schema for every user when I perform the following: >> select * from sys.users Any ideas or suggestions are welcome. Thanks! Luis Ángel. The information transmitted, including any attachments, is intended only for the individual or entity to which it is addressed, and may contain confidential and/or privileged information. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by individuals or entities other than the intended recipient is prohibited, and all liability arising therefrom is disclaimed. If you have received this communication in error, please delete the information from any computer and notify the sender.

2 1

Error while installing Monetdb
by Amit Ambekar 06 May '17

06 May '17

Hi, How much time it will take for new release ? On Wednesday 03 May 2017 03:30 PM, users-list-request(a)monetdb.org wrote: > Error while installing Monetdb

4 5

Problem with release
by Amit Ambekar 03 May '17

03 May '17

Hi, New release of monetdb is not installing on ubuntu 16.04 LTS. I think problem will be your new release which is happened on 1 May 2017. Change https://dev.monetdb.org/downloads/deb/dists/xenial/monetdb/binary-amd64/Rel…: Valid-Until: Tue, 30 Nov 2038 00:00:00 JST this is not working. JST to some other proper format

1 0