Could not find function "collect"

Hi,
I have been using this code for a while and everything was fine:

library(RODBC)

abc <- odbcConnect("LIVESTATS")
ABC.Service.data <- sqlQuery(abc, "SELECT * FROM LIVESTATS.MMF.ServiceFlat")
ABC.Service.dealers <- sqlQuery(abc, "SELECT * FROM LIVESTATS.MMF.Dealers WHERE DataTypeID=2")

A.Service.data <- collect(ABC.Service.data)
A.Service.dealers <- collect(ABC.Service.dealers)

but now I have this error:

Error in collect(ABC.Service.data) : 
  could not find function "collect"


Error in collect(ABC.Service.dealers) : 
  could not find function "collect"

Do you know what that is?

RODBC doesn't seem to have a collect() function or at least no longer has one. It must come from another package that you are overlooking or forgetting about. Possible candidates are dbplyr, SparkR

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.