When I try to connect to a Hive table using:
con <- DBI::dbConnect(odbc::odbc(), 'MyDataBase')
db_tbl <- dplyr::tbl(con, dbplyr::in_schema('my_schema','my_table'))
I get the following error:
Error in UseMethod("tbl") : no applicable method for 'tbl' applied
to an object of class "Hive"
I understand that I am passing "Hive" object to tbl which now is not applicable. However, this code used to work at least in past versions of dplyr and dbplyr. I looked up in the documentation about any changes in the arguments of tbl function, but nothing it says about any changes from previous versions, even in the NEWS section of the packages.
Can you help me find out what should it be the new acceptable arguments for tbl function to read a Hive table in R?
The version of the packages are: dplyr 1.1.4 and dbplyr 2.4.0. Running in Windows 10, R Version 4.3.2