connection error between spark and oracle dv

User_M7MRM

Hi all,

Trying to connect to spark SQL using oracle dv 

some details:

Spark SQL (version 3.2.1)

Driver: Hive JDBC (version 2.3.9)

Oracle dv  (Business Intelligence 12c 12.2.1.4.0)

Spark and oracle dv are on different VMs

ThriftCLIService: Started ThriftHttpCLIService in http mode on port 10000 path=/cliservice/* with 5...500 worker threads

i was able to connect using beeline

beeline> !connect jdbc:hive2://<ipaddress>:10000/mrr;transportMode=http;httpPath=cliservice Connecting to jdbc:hive2://<ipaddress>:10000/mrr;transportMode=http;httpPath=cliservice Enter username for jdbc:hive2://<ipaddress>:10000/mrr: hive Enter password for jdbc:hive2://<ipaddress>:10000/mrr: **** log4j:WARN No appenders could be found for logger (org.apache.hive.jdbc.Utils). log4j:WARN Please initialize the log4j system properly. log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info. Connected to: Spark SQL (version 3.2.1)

but I was unable to connect with oracle dv

got this error

invalid host name <ipaddress> and port name

any idea why?