Data Science & Machine Learning

Hi

In order to select a limited subset (e.g. 10K)  of 3 billion rows, I'd like to use a data frame as bind variable.

Something like "select * from threebilliontable where col1 in ( select col1 from table(:b1))" where b1 is the data frame AND the select should be performed

at the database side.

Or join a data frame with a table (I already tried dbplyr with no success) where the joins is pushed to the database.

Is there a way to do this?

Regards Hans-Peter