RapidMiner

Hive connection error

Wisdom logo Registration now open for RapidMiner Wisdom Americas | New Orleans | October 10-12, 2018   Learn More
Highlighted
Learner I chasrini
Learner I

Hive connection error

Trying to connect to Hive but its failing. Connection being done through kerberos. Below is the error I am getting

 

Exception: eu.radoop.exception.ConnectionException
Message: The following Hadoop configuration properties must be defined, but a connection error prevented the automatic retrieval of these properties: hive.execution.engine, yarn.resourcemanager.scheduler.address, yarn.resourcemanager.resource-tracker.address, yarn.resourcemanager.admin.address, mapreduce.jobhistory.done-dir, mapreduce.jobhistory.intermediate-done-dir, dfs.user.home.dir.prefix.
Stack trace:

eu.radoop.datahandler.HadoopContext.fetchDynamicHadoopSettings(HadoopContext.java:304)
eu.radoop.datahandler.HadoopContext.fetchDynamicHadoopSettings(HadoopContext.java:250)
eu.radoop.datahandler.HadoopContext.getHadoopConfiguration(HadoopContext.java:229)
eu.radoop.datahandler.mapreducehdfs.MapReduceHDFSHandler.getMrhdfsLowLevel(MapReduceHDFSHandler.java:445)
eu.radoop.datahandler.mapreducehdfs.MapReduceHDFSHandler.lambda$testTempPermission$32(MapReduceHDFSHandler.java:1598)
eu.radoop.tools.ExceptionTools.checkOnly(ExceptionTools.java:277)
eu.radoop.datahandler.mapreducehdfs.MapReduceHDFSHandler.testTempPermission(MapReduceHDFSHandler.java:1596)
eu.radoop.RadoopNest.doWork(RadoopNest.java:549)
com.rapidminer.operator.Operator.execute(Operator.java:1025)
com.rapidminer.operator.execution.SimpleUnitExecutor.execute(SimpleUnitExecutor.java:77)
com.rapidminer.operator.ExecutionUnit$2.run(ExecutionUnit.java:812)
com.rapidminer.operator.ExecutionUnit$2.run(ExecutionUnit.java:807)
java.security.AccessController.doPrivileged(Native Method)
com.rapidminer.operator.ExecutionUnit.execute(ExecutionUnit.java:807)
com.rapidminer.operator.OperatorChain.doWork(OperatorChain.java:428)
com.rapidminer.operator.Operator.execute(Operator.java:1025)
com.rapidminer.Process.execute(Process.java:1315)
com.rapidminer.Process.run(Process.java:1290)
com.rapidminer.Process.run(Process.java:1181)
com.rapidminer.Process.run(Process.java:1134)
com.rapidminer.Process.run(Process.java:1129)
com.rapidminer.Process.run(Process.java:1119)
com.rapidminer.gui.ProcessThread.run(ProcessThread.java:65)

Cause
Exception: eu.radoop.exception.NoStackTraceOperatorException
Message: HiveQL error. Message: Connection error for Driver "HiveDriverShim (radoop_hive_0.13.0): org.apache.hive.jdbc.HiveDriver@6e9d60e1" with URL "radoop_hive_0.13.0jdbc:hive2://sl73caehmp04.visa.com:10000/default;principal=hive/sl73caehmp04.visa.com@HADOOP.A...
Stack trace:


Cause
Exception: eu.radoop.datahandler.hive.StatementPool$HiveDriverException
Message: Connection error for Driver "HiveDriverShim (radoop_hive_0.13.0): org.apache.hive.jdbc.HiveDriver@6e9d60e1" with URL "radoop_hive_0.13.0jdbc:hive2://sl73caehmp04.visa.com:10000/default;principal=hive/sl73caehmp04.visa.com@HADOOP.ANA.VISA.COM;auth=kerberos;kerberosAuthType=fromSubject;sasl.qop=auth": Could not open client transport with JDBC Uri: jdbc:hive2://sl73caehmp04.visa.com:10000/default;principal=hive/sl73caehmp04.visa.com@HADOOP.ANA.VISA.COM;auth=kerberos;kerberosAuthType=fromSubject;sasl.qop=auth: java.net.ConnectException: Connection timed out: connect
Stack trace:

1 REPLY
RM Staff RM Staff
RM Staff

Re: Hive connection error

Hi,

Are you getting that error in a full test of the connection? Could you please share the full log?

 

Regards,

Jesús