Error: Could not open client transport with JDBC Uri: jdbc:hive2://:10000/ transportMode=binary: : Connection refused (state=08S01,code=0)Įrror: Could not open client transport with JDBC Uri: jdbc:hive2://:10000/ transportMode=binary:. I searched google and found numerous guides and examples like this: HiveServer2 clients. Tries=, try_sleep=_sleep)įile "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 70, in innerįile "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 92, in checked_callįile "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 140, in _call_wrapperįile "/usr/lib/python2.6/site-packages/resource_management/core/shell.py", line 291, in _callįail: Execution of '! beeline -u 'jdbc:hive2://:10000/ transportMode=binary' -e '' 2>&1| awk ''|grep -i -e 'Connection refused' -e 'Invalid URL'' returned 1. I need to connect to Hive from Java program via JDBC. The following is the error from hiveserver2 log when it is down.Ĭonnection failed on host :10000 (Traceback (most recent call last):įile "/var/lib/ambari-agent/cache/common-services/HIVE/0.12.0.2.0/package/alerts/alert_hive_thrift_port.py", line 200, in executeĬheck_command_timeout=int(check_command_timeout))įile "/usr/lib/python2.6/site-packages/resource_management/libraries/functions/hive_check.py", line 74, in check_thrift_port_saslįile "/usr/lib/python2.6/site-packages/resource_management/core/base.py", line 154, in _init_įile "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 160, in runįile "/usr/lib/python2.6/site-packages/resource_management/core/environment.py", line 124, in run_actionįile "/usr/lib/python2.6/site-packages/resource_management/core/providers/system.py", line 238, in action_run Now when I restarted DBVisualizer, I connected to hive just fine and I can query it using DBVisualizer.HiveServer2 is constantly going down and it works max for a day when we restart. I downloaded these jars from maven centralĪnd again I went inside Tools->DriverManager -> Hive -> user defined and clicked on folder on right hand side and selected each of these jars as well. Here I saw that the mysterious "UndeclaredThrowableException" is occuring because a bunch of class files like http utils, http core, hadoop core, hive core and hive cli jar files were missing. In order to resolve the above, I you need to see the error log. Now when I tried to connect, I still got errors. Now define connection to Hive using these parameters For more information on the Hive JDBC Interface, see HiveJDBCInterface. The information in this document demonstrates how to connect programmatically, and from the SQuirreL SQL client. To submit Apache Hive queries to Apache Hadoop in Azure HDInsight. click on the "folder icon" on the right hand side and select all the jar files which you just unzipped. Learn how to use the JDBC driver from a Java application. I want to setup my db visualizer such that I can query hive database from the dbvisualizer tool. Now go to Tools -> driver manager and select Hive. I am using DBVisualizer 9.2 and Cloudera 5.4.1. Enter the following in the URL Format box: view source. In DBVisualizer, click Tools -> Driver Manager -> Create a New Driver. Now when I restarted DBVisualizer, I connected to hive just fine and I can query it using DBVisualizer.
0 Comments
Leave a Reply. |