Forum Stats

  • 3,757,793 Users
  • 2,251,267 Discussions
  • 7,869,917 Comments

Discussions

ORAAH: Connecting to HIVE with ore.connect

Sherry Lamonica-Oracle
Sherry Lamonica-Oracle Posts: 437 Employee
edited Nov 14, 2017 1:27PM in R Technologies

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([email protected],”Ljava/sql/connection;” ,”connect”, as.character(url)[1]

  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)

Tagged: