For ORAAH 2.6.0 and later, you may encounter this error when connecting to HIVE:
R> ore.connect(type = "HIVE")
Error
Infor: jdbc.Utils: Supplied authorities: localhost:10000
Error in jcall(drv@jdrv,”Ljava/sql/connection;” ,”connect”, as.character(url)[1]
- Java.sql.SQLException: Could not open client transport withJDBC Uri jdbc:hive2://localhost:10000/default: java.net.ConnectionExceptiopn Connection refused
Starting with ORAAH 2.6.0, we use a new driver for connecting to HIVE, and we need the following command:
R> ore.connect(type = "HIVE", host = '<hostname>', user = '<username>', password = '<password>', port = '10000', all = TRUE)