Hello,
I have a similar but not exactly the same issue.
I am running Rstudio on EC2. RODBC works in R (shell), but not in Rstudio. I ran the commands below in Rstudio:
library(RODBC)
ch = odbcConnect('BDP3_Hive')
and got the following error message:
1: In RODBC::odbcDriverConnect("DSN=BDP3_Hive") :
[RODBC] ERROR: state 08001, code 10380, message [Cloudera][ODBC] (10380) Unable to establish a connection with data source. Missing settings: {[Host] [Port]}
2: In RODBC::odbcDriverConnect("DSN=BDP3_Hive") : ODBC connection failed
Rstudio Edition: Desktop
Rstudio Version: 0.99.489
OS Version: RHEL Server 7.4
R version: 3.4.3
I'd love to provide other relevant information if you tell me how to obtain them.