27 Aug
2015
27 Aug
'15
6:16 p.m.
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