Dplyr::tbl not working with HIVE

[martin.R]

Have you tried it without the src_dbi bit?

@mikeC

kp1<-tbl(src_dbi(conn),“coreprofileformammain”)

i.e.
kp1<-tbl(conn,“coreprofileformammain”)

I use odbc to connect to Hive and it works very well with dbplyr which you have in your list.

RJDBC is not the preferred connection method as mentioned in another thread:

Why does RStudio documentation recommend odbc vs jdbc drivers?

I'd say the order of preference is roughly: Native database driver implemented in database package (e.g. RPostgresSQL) ODBC as implemented in odbc package JDBC as implemented in rjdbc package But if you're connecting to a bunch of databases that all have ODBC drivers, you might prefer the increased consistency of using odbc for everything.

Also check:
https://db.rstudio.com/