You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Aug 12, 2020. It is now read-only.
I want to create a table (permanent or not) as a result of some data manipulation without transfering data to R (only keeping data in MonetDB server), but the compute() function is not working when I use the MonetDB.R() driver, although It works with the MonetDBLite() driver.
Reproducible: Always
Steps to Reproduce:
library(MonetDBLite)
library(DBI)
library(dplyr)
# Connect to the database
conn <- dbConnect(
MonetDB.R(),
host = "localhost",
dbname = "ipea",
user = "monetdb",
password = "monetdb",
timeout = 86400L
)
# Create a table
dbWriteTable(conn, "mtcars", mtcars)
dbListTables(conn)
# Connect to the table
x <- tbl(conn, "mtcars")
View(x)
# Manipulate data
y <- x %>% filter(gear==4)
View(y)
# Compute
z <- compute(y)
dbListTables(conn)
View(z)
# Disconnect from database
dbDisconnect(conn)
Actual Results: empty table
Expected Results: table with manipulate data.
Note that the same code above works well if I use a MonetDBLite connection driver:
I want to create a table (permanent or not) as a result of some data manipulation without transfering data to R (only keeping data in MonetDB server), but the
compute()
function is not working when I use theMonetDB.R()
driver, although It works with theMonetDBLite()
driver.Reproducible: Always
Steps to Reproduce:
Actual Results: empty table
Expected Results: table with manipulate data.
Note that the same code above works well if I use a
MonetDBLite
connection driver:conn <- dbConnect( MonetDBLite(), "C:/MonetDBdata/ipea" )
The text was updated successfully, but these errors were encountered: