Best database to work with R and Rstudio

sergeant :package: can be of help here

It brings Apache Drill to R. It allows to use SQL to deal with very files that do not fit in memory.

There is this topic about out-of-memory that could help you. It mentions sergeant too.