[R] FF package & downloading a large file using sqlQuery

[Jan]

You can use the read.dbi.ffdf and read.odbc.ffdf function in package
ETLUtils. These allow you to fetch a query directly in an ffdf. See the
examples in their corresponding documentation ?read.dbi.ffdf and
?read.odbc.ffdf or look at this blog post
http://www.bnosac.be/index.php/blog/21-readodbcffdf-a-readdbiffdf-for-fetching-large-corporate-sql-data.

But as you are new to R and package ff might not be the best starting
package when you are a newcomer, I suggest you first try to make a simple
connection using ODBC or using the package RPostgreSQL in order to connect
to your database. Once you can connect, use the same connection parameters
in read.dbi.ffdf or read.odbc.ffdf to fetch your large dataset.

good luck



--
View this message in context: http://r.789695.n4.nabble.com/FF-package-downloading-a-large-file-using-sqlQuery-tp4642456p4643393.html
Sent from the R help mailing list archive at Nabble.com.