- users-list - monetdb.org

Facing issues in implementing Embedded R in MonetDB-11.19.11
by Vishal Virmani 12 May '15

12 May '15

Hi I am implementing Embedded R in MonetDB version 11.19.11. My environment is VM with Ubuntu 14.04 Server. I have build MonetDB from source and R as well as from source. Running the command sudo mserver5 --version shows me the desired output. When i try to invoke a database using sudo monetdb start testdb1 command, where testdb1 is a database i successfully created, it repeatedly throws up an error...database 'testdb1' started up, but failed to open up a communication channel. Upon checking the associated merovingian log file i see further messages saying the object code to rapi.prelude missing. Any way to resolve this...? Regards Vishal Virmani @poisoncreed

2 1

Problem selecting entries newer than a certain date
by Maarten Sander 01 May '15

01 May '15

Hi everyone, I’m probably missing something, but it seems that I cannot select entries that are newer than a given timestamp. Below are my attempts and the schema of the table. Any help would be greatly appreciated! Regards, Maarten sql>SELECT completed FROM "reporting"."transactions" WHERE completed >= '2015-04-10 00:00:00.0000' ORDER BY completed DESC; +-----------+ | completed | +===========+ +-----------+ 0 tuples (0.595ms) sql>SELECT completed FROM "reporting"."transactions" WHERE completed >= CAST('2015-04-10 00:00:00.0000' AS TIMESTAMP) ORDER BY completed DESC; +-----------+ | completed | +===========+ +-----------+ 0 tuples (0.328ms) sql>SELECT completed FROM "reporting"."transactions" ORDER BY completed DESC LIMIT 10; +----------------------------+ | completed | +============================+ | 2015-04-10 11:50:22.051000 | | 2015-04-10 10:55:50.039000 | | 2015-04-09 09:41:13.023000 | | 2015-04-09 09:39:09.079000 | | 2015-04-09 09:35:56.085000 | | 2015-04-08 12:55:13.007000 | | 2015-04-08 12:37:07.002000 | | 2015-04-08 12:28:22.000000 | | 2015-04-08 12:25:25.052000 | | 2015-04-07 21:59:59.099000 | +----------------------------+ 10 tuples (0.683ms) sql>\d "reporting"."transactions" CREATE TABLE "reporting"."transactions" ( "id" CHAR(36) NOT NULL, "status" VARCHAR(25) NOT NULL, "created" TIMESTAMP NOT NULL, "completed" TIMESTAMP, "currency" CHAR(3) NOT NULL, "amount" BIGINT NOT NULL, "balance" VARCHAR(25) NOT NULL, "payment_method" VARCHAR(50) NOT NULL, "fee_currency" CHAR(3), "fee_amount" BIGINT, "order_id" CHAR(36) NOT NULL, "order_status" VARCHAR(25) NOT NULL, "project_id" CHAR(36) NOT NULL, "merchant_id" CHAR(36) NOT NULL, CONSTRAINT "transactions_id_pkey" PRIMARY KEY ("id") );

2 4

Efficient bulk load via JDBC?
by Roberto Cornacchia 29 Apr '15

29 Apr '15

Hello, Is there (or is there a plan for) efficient bulk load via JDBC? (I'm currently running Oct2014 and JDBC 2.13) I looked at: https://www.monetdb.org/book/export/html/340 As far as I understand, the most efficient way currently available in JDBC is to use batches of inserts via prepared statements (with autocommit off). Unfortunately this does not get even close to be fast enough. The speed of a COPY INTO is what I am looking for. But, this is not supported via JDBC. Is there a specific reason, or is it simply not implemented? I do know about the workaround of performing the COPY INTO via mapi protocol (like in http://dev.monetdb.org/hg/MonetDB/file/tip/java/example/SQLcopyinto.java) This provides good speed indeed. However, it is not transaction-safe. When I use this method, and some SQL transaction happens to read (only read!) from the same tables at the same time, then I often get data corruption: the COPY INTO seems to end well (and the data gets actually in place), but new SQL queries on those tables fail with a "BATproject: does not match always" GDK error (checking with gdb I see that the right side of a fetchjoin has count 0). Any idea?

3 4

How to CREATE TRIGGER with a schema-qualifies table?
by Robert Koch 29 Apr '15

29 Apr '15

I have a schema "test" with 2 tables. I want to create a trigger inside this schema bound to a table inside this schema. sql>create trigger test.trigger1 after update on test.profiletab insert into test.triggerlog; syntax error, unexpected '.', expecting WHILE in: "create trigger test.trigger1 after update on test." Thank you.

1 0

INSERT DEFAULT values only
by Robert Koch 28 Apr '15

28 Apr '15

How can I insert a row with default values only? CREATE TABLE test.tbl1 ( id bigint DEFAULT NEXT VALUE FOR "my_test_seq" NOT NULL, instime DATE DEFAULT now() NOT NULL ); Both insert into test.triggerlog (id) VALUES (10000); and insert into test.triggerlog (instime) VALUES (now()); work. Neither insert into test.triggerlog (id, instime) VALUES (DEFAULT, DEFAULT); nor insert into test.triggerlog (id, instime) VALUES (); work. What is the correct statement? Thank you.

1 1

Confusing if MonetDB RDF/SparQL is supported
by Aris Setyawan 27 Apr '15

27 Apr '15

Hi All, In the recent week, I monitoring the monet's development commit logs. >From that logs, I have found that "RDF support was removed". But in the next log, some features under RDF was added. I'm bit confused about this. What is the state of RDF support in MonetDB? Thanks, -Aris

1 0

Parallel Query
by Luciano Sasso 25 Apr '15

25 Apr '15

Hi, 1- On a single server, the query is executed in parallel?, Common relational database also has this ability (SQL Server, PostgreSQL etc.)? 2- And in a cluster, the same query is distributed for cluster nodes , in MonetDB? Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

2 1

How to create a user with administrator rights
by Puthick Hok 24 Apr '15

24 Apr '15

Hi, I wan to use "COPY INTO table from 'file'" SQL instruction with a user rather than monetdb. This user needs the administrator rights. So far I have done these using monetdb user as the login: CREATE USER "mdb_user" WITH PASSWORD '"password"' NAME 'Test db user' SCHEMA "sys"; CREATE ROLE "testdbadmin" WITH ADMIN CURRENT_USER; GRANT "testdbadmin" TO "mdb_user" WITH ADMIN OPTION; CREATE SCHEMA "testdb" AUTHORIZATION "mdb_user"; ALTER USER "mdb_user" SET SCHEMA "testdb"; I learnt this from MonetDB UserGuide tutorial and from MonetDB authorisation documentation. However, I still cannot use 'mdb_user' for COPY INTO from file command. What is missing? What does 'ADMIN OPTION' do? How to make 'mdb_user' have the same right as monetdb? At the moment, I'm using monetdb user directly. But, it would be a bit nicer to have a different username. I'm working on a web service connecting to 3 different databases: mysql, postgres and now monetdb. They have a common username for the database connection. If I keep using monetdb user, the commonality rule is broken. I have another to use 'mdb_user' via STDIN and piping, but exporting DOTMONETDBFILE as an environment variable to make mclient login with out asking for password is another complexity dimension. Making mdb_user to have administrator rights like monetdb is the best option for me if this is possible, and I hope this is possible. Regards, Puthick

2 2

MonetDB Cluster
by Luciano Sasso 23 Apr '15

23 Apr '15

Hi, Cluster MonetDB is only partitioning or is replication, or all? Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0

Database Size
by Luciano Sasso 23 Apr '15

23 Apr '15

Hi, What is the largest (size in G) database that you have worked? on a single server or cluster. Att, -- Luciano Sasso Vieira Data Scientist & Solutions Architect luciano(a)gsgroup.com.br <http://www.gsgroup.com.br> | tel: 17 3353-0833 | cel: 17 99706-9335 www.gsgroup.com.br <http://www.gsgroup.com.br> --- Este email foi escaneado pelo Avast antivírus. http://www.avast.com

1 0