R: Out of memory approach to rbind large data.frames using MonetDBLite

335 Views Asked by At

I would like to mimic the solution once given to this question: R: how to rbind two huge data-frames without running out of memory, but using R::MonetDBLite rather than R::SQLite

I tried the following without success:

library(DBI)
library(MonetDB.R)
library(MonetDBLite)
library(sqldf)

m <- dbDriver("MonetDBLite")

invisible(
sqldf::sqldf("create table test_table as select * from data1 union select * from data2",
      dbname="test.monetdb",
      drv=m,
      verbose = TRUE)
)

Thanks for your help.

edit: the error I get

Error in drv == "" :
comparison (1) is possible only for atomic and list types
Error in !dbPreExists : invalid argument type
Timing stopped at: 0 0 0 

Session informations:

R version 3.3.0 (2016-05-03)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1
locale:
[1] LC_COLLATE=French_France.1252  LC_CTYPE=French_France.1252
LC_MONETARY=French_France.1252 LC_NUMERIC=C
LC_TIME=French_France.1252
attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base
other attached packages:
[1] sqldf_0.4-10      RSQLite_1.0.0     gsubfn_0.6-6      proto_0.3-10
MonetDBLite_0.2.2 DBI_0.4-1         MonetDB.R_1.0.1
loaded via a namespace (and not attached):
[1] tools_3.3.0      codetools_0.2-14 digest_0.6.9     chron_2.3-47
tcltk_3.3.0 
0

There are 0 best solutions below