I am trying to open a big file (~3GB) using sqlfd. I've just installed sqldf 0.4.9 on R version 3.1.1 for Mac OS X 10.9.2.
While trying to open the file like this:
f <- file("preprocessed.csv")
df <-sqldf("select * from f")
I get the following error:
Error in .local(conn, name, value, ...) :
unused arguments (comment.char = "", quote = "\"")
The same happens when I use read.csv.sql().
What am I doing wrong?
Thank you.
Best regards
Hi there,I am trying to open a big file (~3GB) using sqlfd. I've just installed sqldf 0.4.9 on R version 3.1.1 for Mac OS X 10.9.2.
While trying to open the file like this:
f <- file("preprocessed.csv")
df <-sqldf("select * from f")I get the following error:
Error in .local(conn, name, value, ...) :
unused arguments (comment.char = "", quote = "\"")The same happens when I use read.csv.sql().
In looking at this further there is an additional difference in RSQLite 1.0.0 (relative to the prior version) that was recently uploaded to CRAN that causes this.A fix is in googlecode repo at http://sqldf.googlecode.com .Until this fixed version is on CRAN you can:1. build the new version from source, or2. source the fixed sqldf.R on the fly like this: