% JDBC (hive) -无法使用JDBC打开客户端传输

Question

我试图使用Zeppelin上的JDBC驱动程序运行一些蜂巢查询。

当我运行这个命令时，%jdbc(hive)

作为响应错误，我会被跟踪。

java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://localhost:10000: java.net.ConnectException: Connection refused (Connection refused)

下面是我的hivesite.xml。

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?><!--
   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.
--><configuration>
<property><name>hive.metastore.uris</name><value>thrift://hive-metastore:9083</value></property>
<property><name>datanucleus.autoCreateSchema</name><value>false</value></property>
<property><name>javax.jdo.option.ConnectionURL</name><value>jdbc:postgresql://hive-metastore-postgresql/metastore</value></property>
<property><name>javax.jdo.option.ConnectionDriverName</name><value>org.postgresql.Driver</value></property>
<property><name>javax.jdo.option.ConnectionPassword</name><value>hive</value></property>
<property><name>javax.jdo.option.ConnectionUserName</name><value>hive</value></property>
</configuration>

下面是解释器属性和依赖项。

​

​

更新

我在/tmp/root/hive.log文件中找到了下面的内容。所以，根本原因一定是细胞亚稳态。

    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

Answer 1

在您的配置中，HS2与齐柏林飞艇位于同一台机器上。是那么回事吗？另外，你能从齐柏林飞艇主机连接到HS2端口吗？测试：

telnet hive_host hive_port (default 10000)

在单元jdbc字符串中，通常在端口之后有一个'/‘来给DB连接，而您的端口是空的，我建议将这个字符串修改为：

jdbc:hive2://$HIVE_HOST:$HIVE_PORT/{DB}

如果在{DB}中没有插入任何内容，HS2将连接到默认数据库。