dplyr & monetdb - appropriate syntax for querying schema.table?
I’ve just posted the following on stackoverflow. Any help is welcome!
In monetdb I have set up a schema main and my tables are created into this schema.
For example, the department table is main.department.
With dplyr I try to query the table:
mdb <- src_monetdb(dbname="model", user="monetdb", password="monetdb")
tbl(mdb, "department") But I get
Error in .local(conn, statement, ...) : Unable to execute statement 'PREPARE SELECT * FROM "department"'. Server says 'SELECT: no such table 'department'' [#42S02]. I tried to use "main.department" and other similar combinations with no luck.
What is the appropriate syntax?
Enzo enzo@smartinsightsfromdata.com
Answered on SO. Basically, SET SCHEMA http://stackoverflow.com/a/32295034/2652376
On 27 Aug 2015, at 20:16, Enzo enzo@smartinsightsfromdata.com wrote:
I’ve just posted the following on stackoverflow. Any help is welcome!
In monetdb I have set up a schema main and my tables are created into this schema.
For example, the department table is main.department.
With dplyr I try to query the table:
mdb <- src_monetdb(dbname="model", user="monetdb", password="monetdb")
tbl (mdb, "department") But I get
Error in .local(conn, statement, ...) :
Unable to execute statement 'PREPARE SELECT * FROM "department"' . Server says 'SELECT: no such table 'department'' [#42S02]. I tried to use "main.department" and other similar combinations with no luck.
What is the appropriate syntax?
Enzo enzo@smartinsightsfromdata.com
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Enzo -
Hannes Mühleisen