search for: rs_sqlite_import

...sfer before trying to import just the rows I need into R. The problem is that I get this error: > f <- file("hugedata.csv") > DF <- sqldf("select * from f where C_OPR like 'KKA2%'", file.format=list(header=T, row.names=F)) Error in try({ : RS-DBI driver: (RS_sqlite_import: hugedata.csv line 1562740 expected 52 columns of data but found 19) Error in sqliteExecStatement(con, statement, bind.data) : RS-DBI driver: (error in statement: no such table: f) Now, I know that my SAS-using colleagues are able to use this file with SAS, so I was wondering whether StatTransf...

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...

...aseca\n 3 27.43334 Manchuria 1931 Morris\n > barley$site <- as.character (barley$site) > barley$site[1] <- "University, Farm" > dbWriteTable (db, "barley", barley, overwrite = TRUE) Error in sqliteWriteTable(conn, name, value, ...) : RS-DBI driver: (RS_sqlite_import: /tmp/RtmpgSNaLn/rsdbi6a5d128c line 1 expected 5 columns of data but found 6) I'm using RSQLite 0.4.0 with R 2.1.1 on Mac OS X. Cheers, Michael

Dear list, I need to read in a big table with 487 columns and 238,305 rows (row names and column names are supplied). Is there a code to read in the table in a fast way? I tried the read.table() but it seems that it takes forever :( Thanks a lot! Best, Allen