title: %jdbc(hive) - Could not open client transport with JDBC Uri
body: <p>I'm trying to run some hive queries using JDBC driver on Zeppelin.</p>
  
  <p>When I run this command,     <code>%jdbc(hive)</code> </p>
  
  <p>I get following as the response error.</p>
  
  <pre><code>java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (Connection refused)
  </code></pre>
  
  <p>Following is my hive-site.xml.</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="no"?&gt;
  &lt;?xml-stylesheet type="text/xsl" href="configuration.xsl"?&gt;&lt;!--
     Licensed to the Apache Software Foundation (ASF) under one or more
     contributor license agreements.  See the NOTICE file distributed with
     this work for additional information regarding copyright ownership.
     The ASF licenses this file to You under the Apache License, Version 2.0
     (the "License"); you may not use this file except in compliance with
     the License.  You may obtain a copy of the License at
  
         http://www.apache.org/licenses/LICENSE-2.0
  
     Unless required by applicable law or agreed to in writing, software
     distributed under the License is distributed on an "AS IS" BASIS,
     WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
     See the License for the specific language governing permissions and
     limitations under the License.
  --&gt;&lt;configuration&gt;
  &lt;property&gt;&lt;name&gt;hive.metastore.uris&lt;/name&gt;&lt;value&gt;thrift://hive-metastore:9083&lt;/value&gt;&lt;/property&gt;
  &lt;property&gt;&lt;name&gt;datanucleus.autoCreateSchema&lt;/name&gt;&lt;value&gt;false&lt;/value&gt;&lt;/property&gt;
  &lt;property&gt;&lt;name&gt;javax.jdo.option.ConnectionURL&lt;/name&gt;&lt;value&gt;jdbc:postgresql://hive-metastore-postgresql/metastore&lt;/value&gt;&lt;/property&gt;
  &lt;property&gt;&lt;name&gt;javax.jdo.option.ConnectionDriverName&lt;/name&gt;&lt;value&gt;org.postgresql.Driver&lt;/value&gt;&lt;/property&gt;
  &lt;property&gt;&lt;name&gt;javax.jdo.option.ConnectionPassword&lt;/name&gt;&lt;value&gt;hive&lt;/value&gt;&lt;/property&gt;
  &lt;property&gt;&lt;name&gt;javax.jdo.option.ConnectionUserName&lt;/name&gt;&lt;value&gt;hive&lt;/value&gt;&lt;/property&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p>Following are the Interpreter properties and dependencies.</p>
  
  <p><a href="https://i.stack.imgur.com/lCxwo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/lCxwo.png" alt="enter image description here"></a></p>
  
  <p><strong>Updates</strong></p>
  
  <p>I found below in <code>/tmp/root/hive.log</code> file. So, the root cause must be at hive-metastore.</p>
  
  <pre><code>    2019-01-14T10:58:56,379 INFO  [main]: hive.metastore (:()) - Trying to connect to metastore with URI thrift://hive-metastore:9083
  .....
  .....
  2019-01-14T10:58:59,660 INFO  [main]: server.HiveServer2 (HiveServer2.java:stop(476)) - Shutting down HiveServer2
  </code></pre>