Hi,
I was trying to read & filter records from a large file using read.csv.sql.
I was successfully able to do that with a ~1 GB file. However I get the
following error with a >2 GB file which has exactly the same structure as
the first file.
*Error in try({ : *
* RS-DBI driver: (RS_sqlite_import: cannot open file <filename> )*
-I have checked the file permission and the file exists in the directory.
-The error comes instantly, so I am assuming its not due to memory.
-If I skip significant number of rows(using skip= statement) from the > 2GB
file, I don't get the error.
I can do a quick and dirty fix by splitting the file into two and by
performing two separate reads, but may be thats not so elegant. Can somebody
please help?
--
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
