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?