Error: Could not open client transport with JDBC Uri: jdbc:hive2://slave3:10000: java.net.ConnectExc

最新推荐文章于 2025-10-29 19:58:18 发布
原创 最新推荐文章于 2025-10-29 19:58:18 发布 · 1.9k 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#java #hive #zookeeper #jdbc

HIVE客户端连接服务端：拒绝连接 问题

报错如下：

WARN jdbc.HiveConnection: Failed to connect to slave3:10000
Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask the administrator to check the server status.
Error: Could not open client transport with JDBC Uri: jdbc:hive2://slave3:10000: java.net.ConnectException: 拒绝连接 (Connection refused) (state=08S01,code=0)

原因是因为hive服务没有启动

执行命令：hive --service hiveserver2 &

客户端连接成功

 

转载自：https://blog.youkuaiyun.com/zt15732625878/article/details/87562838

 

 

Hive连接报错：Could not open client transport with JDBC Uri: jdbc:hive2://192.168.216.128:10000
zhengzaifeidelushang的博客
05-19 5223
Hive连接报错： Could not open client transport with JDBC Uri: jdbc:hive2://192.168.216.128:10000: java.net.ConnectException: Connection refused: connect java.net.ConnectException: Connection refused: connect java.net.ConnectException: Connection refused: connec
Hive beeline客户端启动报错Could not open client transport with JDBC Uri: jdbc:hive2://hadoop101:10000: Fail
qq_32118757的博客
01-14 4279
Hive beeline客户端启动报错`Could not open client transport with JDBC Uri: jdbc:hive2://hadoop101:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): Use
Hive Beeline连接报错：Could not open client transport with JDBC Uri: jdbc:hive2://hcmaster:10000/default
01-20
问题 解决方案 在hadoop的配置文件core-site.xml增加如下配置： hadoop.proxyuser.hc.hosts * hadoop.proxyuser.hc.groups * 其中“hc”是连接beeline的用户。 启动测试 重启hdfs：先stop-all.sh，再start-all.sh，否则不会生效。 启动hiverserver2 查看是否启动：netstat -anp | grep 10000 3. 连接hiveserver2 作者：梁云亮
Could not open connection to the HS2 server. Please check the server URI and if the URI is correct
m0_75270563的博客
10-29 1838
Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask the administrator to check the server status. Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000: java.net.ConnectE
beeline报错：Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000
weixin_52619195的博客
06-28 1639
解决beeline无法启动的问题
hive中 beeline连接时报错
qq_37668945的博客
11-01 3095
错误1. Error: Could not open client transport with JDBC Uri: jdbc:hive2://192.168.136.128:10000/mydb/: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org....
我的hive版本是4.0.1,系统是rocky9.4，执行hive命令后显示的是beellin,且输入sql语句后显示no current connection，我输入!connect jdbc:hive2://master:10000 再输入mysql的用户名和密码后报错： Error: Could not open client transport with JDBC Uri: jdbc:hive2://slave1:10000: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0)
04-22
好的，我现在需要帮助用户解决Hive 4.0.1在Rocky Linux 9.4上遇到的JDBC连接拒绝错误，具体是'no current connection'，错误代码state=08S01，code=0。根据用户提供的引用内容，我需要结合这些信息和已有的知识来...
我在弄hive的安装和配置，我在完成Linux中的任务，请帮我根据文档要求完成操作。以下是我的虚拟机信息： 虚拟机版本: CentOS7 用户名为: wyy0212 虚拟机master IP为192.168.161.130 hive压缩包路径/home/wyy0212/apache-hive-3.1.2-bin.tar.gz hadoop路径: /export/server/hadoop hadoop版本: 3.3.3 jdk路径: /export/server/jdk jdk版本: 1.8.0_202 mysql路径: /root/export/server/hadoop/bin/hadoop mysql版本: mysql Ver 15.1 Distrib 5.5.68-MariaDB 目前我在master虚拟机,当前所在路径:/export/server 所有操作均在root下完成(包括master和slave) 我要求一个零基础的终极详细教程，提供从第一步开始的完整操作流程，每个命令都要给出,包括每一步的命令和操作，以及所有代码和配置文件的完整路径和完整内容。涉及编辑的都使用vi 必须提供可以直接复制粘贴的代码和配置文件。请务必详细，不要跳过任何步骤。谢谢。但是现在我遇到问题了[root@master server]# [root@master server]# # 重命名为 hive（简洁） [root@master server]# mv apache-hive-3.1.2-bin hive [root@master server]# vi /etc/profile [root@master server]# source /etc/profile [root@master server]# echo $HIVE_HOME /export/server/hive [root@master server]# cd /export/server/hive/lib [root@master lib]# [root@master lib]# # 删除 Hive 自带的旧版 guava [root@master lib]# rm -f guava-19.0.jar [root@master lib]# [root@master lib]# # 从 Hadoop 复制新版（先查看真实版本号） [root@master lib]# ls /export/server/hadoop/share/hadoop/common/lib/guava-*.jar ls: 无法访问/export/server/hadoop/share/hadoop/common/lib/guava-*.jar: 没有那个文件或目录 [root@master lib]# cd /export/server/hive [root@master hive]# [root@master hive]# # 创建 conf 目录（如果不存在） [root@master hive]# mkdir -p conf [root@master hive]# [root@master hive]# # 进入配置目录 [root@master hive]# cd conf [root@master conf]# vi hive-site.xml [root@master conf]# cp /export/soft/mysql-connector-java-5.1.49.jar /export/server/hive/lib/ [root@master conf]# ls /export/server/hive/lib/mysql-connector-java-5.1.49.jar /export/server/hive/lib/mysql-connector-java-5.1.49.jar [root@master conf]# mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 5 Server version: 5.7.43 MySQL Community Server (GPL) Copyright (c) 2000, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type &#39;help;&#39; or &#39;\h&#39; for help. Type &#39;\c&#39; to clear the current input statement. mysql> -- 创建 hive 数据库 mysql> CREATE DATABASE IF NOT EXISTS hive CHARACTER SET utf8 COLLATE utf8_general_ci; Query OK, 1 row affected (0.10 sec) mysql> mysql> -- 授权 root 用户访问 hive 库（因为我们用 root 连接） mysql> -- 注意：生产环境建议新建专用用户，这里简化操作 mysql> GRANT ALL PRIVILEGES ON hive.* TO &#39;root&#39;@&#39;%&#39;; Query OK, 0 rows affected (0.07 sec) mysql> mysql> -- 刷新权限 mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.01 sec) mysql> mysql> -- 退出 mysql> EXIT; Bye [root@master conf]# cd /export/server/hive [root@master hive]# [root@master hive]# # 执行 schematool 初始化 [root@master hive]# bin/schematool -dbType mysql -initSchema -verbose SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/export/server/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/root/export/server/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Exception in thread "main" java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V at org.apache.hadoop.conf.Configuration.set(Configuration.java:1357) at org.apache.hadoop.conf.Configuration.set(Configuration.java:1338) at org.apache.hadoop.mapred.JobConf.setJar(JobConf.java:518) at org.apache.hadoop.mapred.JobConf.setJarByClass(JobConf.java:536) at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:430) at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:5141) at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:5104) at org.apache.hive.beeline.HiveSchemaTool.<init>(HiveSchemaTool.java:96) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:1473) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:318) at org.apache.hadoop.util.RunJar.main(RunJar.java:232) [root@master hive]# # 创建日志目录 [root@master hive]# mkdir -p /export/server/hive/logs [root@master hive]# [root@master hive]# # 启动 Metastore（后台运行） [root@master hive]# nohup /export/server/hive/bin/hive --service metastore \ > > /export/server/hive/logs/metastore.log 2>&1 & [1] 124844 [root@master hive]# [root@master hive]# # 查看是否启动成功 [root@master hive]# tail -f /export/server/hive/logs/metastore.log nohup: 忽略输入 2025-11-26 22:50:08: Starting Hive Metastore Server SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/export/server/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/root/export/server/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] MetaException(message:com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:84) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:93) at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:8661) at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:8656) at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:8926) at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:8843) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:318) at org.apache.hadoop.util.RunJar.main(RunJar.java:232) Caused by: java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V at org.apache.hadoop.conf.Configuration.set(Configuration.java:1357) at org.apache.hadoop.conf.Configuration.set(Configuration.java:1338) at org.apache.hadoop.hive.metastore.ObjectStore.correctAutoStartMechanism(ObjectStore.java:641) at org.apache.hadoop.hive.metastore.ObjectStore.getDataSourceProps(ObjectStore.java:572) at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:349) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:77) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:137) at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:59) at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:718) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:696) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:690) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:767) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:538) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:108) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:80) ... 11 more Exception in thread "main" MetaException(message:com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:84) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.getProxy(RetryingHMSHandler.java:93) at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:8661) at org.apache.hadoop.hive.metastore.HiveMetaStore.newRetryingHMSHandler(HiveMetaStore.java:8656) at org.apache.hadoop.hive.metastore.HiveMetaStore.startMetaStore(HiveMetaStore.java:8926) at org.apache.hadoop.hive.metastore.HiveMetaStore.main(HiveMetaStore.java:8843) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:318) at org.apache.hadoop.util.RunJar.main(RunJar.java:232) Caused by: java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V at org.apache.hadoop.conf.Configuration.set(Configuration.java:1357) at org.apache.hadoop.conf.Configuration.set(Configuration.java:1338) at org.apache.hadoop.hive.metastore.ObjectStore.correctAutoStartMechanism(ObjectStore.java:641) at org.apache.hadoop.hive.metastore.ObjectStore.getDataSourceProps(ObjectStore.java:572) at org.apache.hadoop.hive.metastore.ObjectStore.setConf(ObjectStore.java:349) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:77) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:137) at org.apache.hadoop.hive.metastore.RawStoreProxy.<init>(RawStoreProxy.java:59) at org.apache.hadoop.hive.metastore.RawStoreProxy.getProxy(RawStoreProxy.java:67) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.newRawStoreForConf(HiveMetaStore.java:718) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMSForConf(HiveMetaStore.java:696) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.getMS(HiveMetaStore.java:690) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:767) at org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:538) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invokeInternal(RetryingHMSHandler.java:147) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.invoke(RetryingHMSHandler.java:108) at org.apache.hadoop.hive.metastore.RetryingHMSHandler.<init>(RetryingHMSHandler.java:80) ... 11 more ^C [1]+ 退出 1 nohup /export/server/hive/bin/hive --service metastore > /export/server/hive/logs/metastore.log 2>&1 [root@master hive]# # 启动 HiveServer2 [root@master hive]# nohup /export/server/hive/bin/hive --service hiveserver2 \ > > /export/server/hive/logs/hiveserver2.log 2>&1 & [1] 126010 [root@master hive]# [root@master hive]# # 查看日志 [root@master hive]# tail -f /export/server/hive/logs/hiveserver2.log nohup: 忽略输入 which: no hbase in (/usr/local/bin:/usr/bin:/usr/sbin:/bin:/sbin:/export/server/jdk/bin:/export/server/hadoop/bin:/export/server/hadoop/sbin:/export/server/mysql/bin:/export/server/hive/bin) 2025-11-26 22:50:53: Starting HiveServer2 SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/export/server/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/root/export/server/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Exception in thread "main" java.lang.NoSuchMethodError: com.google.common.base.Preconditions.checkArgument(ZLjava/lang/String;Ljava/lang/Object;)V at org.apache.hadoop.conf.Configuration.set(Configuration.java:1357) at org.apache.hadoop.conf.Configuration.set(Configuration.java:1338) at org.apache.hadoop.mapred.JobConf.setJar(JobConf.java:518) at org.apache.hadoop.mapred.JobConf.setJarByClass(JobConf.java:536) at org.apache.hadoop.mapred.JobConf.<init>(JobConf.java:430) at org.apache.hadoop.hive.conf.HiveConf.initialize(HiveConf.java:5141) at org.apache.hadoop.hive.conf.HiveConf.<init>(HiveConf.java:5099) at org.apache.hadoop.hive.common.LogUtils.initHiveLog4jCommon(LogUtils.java:97) at org.apache.hadoop.hive.common.LogUtils.initHiveLog4j(LogUtils.java:81) at org.apache.hive.service.server.HiveServer2.main(HiveServer2.java:1141) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:318) at org.apache.hadoop.util.RunJar.main(RunJar.java:232) ^C [1]+ 退出 1 nohup /export/server/hive/bin/hive --service hiveserver2 > /export/server/hive/logs/hiveserver2.log 2>&1 [root@master hive]# jps 96417 DataNode 96162 NameNode 126676 Jps 103240 ResourceManager 103483 NodeManager 96894 SecondaryNameNode [root@master hive]# /export/server/hive/bin/beeline SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/export/server/hive/lib/log4j-slf4j-impl-2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/root/export/server/hadoop/share/hadoop/common/lib/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Beeline version 3.1.2 by Apache Hive beeline> !connect jdbc:hive2://192.168.161.130:10000 Connecting to jdbc:hive2://192.168.161.130:10000 Enter username for jdbc:hive2://192.168.161.130:10000: root Enter password for jdbc:hive2://192.168.161.130:10000: 25/11/26 22:51:47 [main]: WARN jdbc.HiveConnection: Failed to connect to 192.168.161.130:10000 Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask the administrator to check the server status. Error: Could not open client transport with JDBC Uri: jdbc:hive2://192.168.161.130:10000: java.net.ConnectException: 拒绝连接 (Connection refused) (state=08S01,code=0) beeline> SHOW DATABASES; No current connection beeline> # 开放 Metastore 端口 beeline> firewall-cmd --permanent --add-port=9083/tcp . . . .> . . . .> # 开放 HiveServer2 端口 . . . .> firewall-cmd --permanent --add-port=10000/tcp . . . .> . . . .> # 重新加载 . . . .> firewall-cmd --reload . . . .> exit; No current connection beeline> !quit [root@master hive]#
最新发布
11-27
connect jdbc:hive2://192.168.161.130:10000 ``` 输入用户名：`root` 输入密码：`123456` 成功后执行： ```sql SHOW DATABASES; ``` 预期输出： ``` +----------------+--+ | database_name ...
hadoop错题本
epitomizelu的专栏
04-02 3260
一，hive的启动失败 可能原因： 1，hive依赖于hadoop集群的启动，如果hadoop集群没有启动，hive启动会失败 2，配置文件错误 hive安装路径下hive-env.sh中的HIVE_CONF_DIR配置错误
搭建Hadoop+Hive+Mysql遇到的坑及解决办法
wqhlmark64的博客
06-13 6223
1. 安装环境     硬件：三台PC，配置 Intel i5 4 Core CPU, 16G memory,  2T 硬盘     软件： 两台PC为ubuntu 14.04, 一台为ubuntu 16.04 ;    hadoop-2.8.0, hive-1.2.2, mysql 5.5.55, jdk-8u131-linux-x64.tgz (1.8.0_131)     机器分配
Hive架构及搭建方式
weixin_38166318的博客
10-23 999
Hive架构及搭建方式 [TOC] 前言 本文档基于hive 3.1.2编写 hive的基础知识 基本架构 整个hive由hiveserver2和hive 客户端组成 hive客户端有三种，beeline 、使用jdbc链接hiveserver、或使用hive CLI(这个已经过时，hive官方已经不推荐，推荐beeline) hive server本身由hive server2和metastore组成 metastore是hive的元数据管理组件 hcatalog 架设在metastore上，暴露一组
启动beeline客户端出现Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000:
m0_74857268的博客
08-29 1035
3.启动MySQL（这里的密码是123456）2.后台启动hiveservice2。4.输入beeline，启动成功。
Could not open client transport with JDBC Uri: jdbc:hive2://node03:10000: java.net.ConnectException:
qq_40233706的博客
10-21 3万+
启动beeline连接hive报错： Could not open client transport with JDBC Uri: jdbc:hive2://node03:10000: java.net.ConnectException: 原因是hiveserver2没有启动起来 beeline连接hive命令（注意我的节点名node03，其他人可能根据自己设置的不同）：!connect j...
Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000: Failed to open..
weixin_46005650的博客
04-10 8985
在hive目录下使用beeline命令： bin/beeline -u jdbc:hive2://hadoop102:10000 -n fei 具体的报错信息如下所示： 22/04/10 01:13:24 [main]: WARN jdbc.HiveConnection: Failed to connect to hadoop102:10000 Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102.
出现Error: Could not open client transport with JDBC Uri: jdbc:hive2://node02:10000/；user=root:..怎么办？
m0_73139998的博客
05-28 4373
解决hive远程部署出现 Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.User: root is not allowed to impersonate root或者java.net.ConnectException:Connection refused (Connection refused)
Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop103:10000: java.net.Connect
pcOnline_TT的博客
09-02 3807
在配置hive的时候报这个错误，Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop103:10000: java.net.ConnectException: 拒绝连接 (Connection refused) (state=08S01,code=0) 网上看了很多什么jar包冲突等等都没有解决。 最后在b站有同志给出了解决方法，我用了很有效。 设置impersonation，这样hive server会以提交用户
Could not open client transport with JDBC Uri: jdbc:hive2://192.168.88.10:10000: java.net.ConnectExc
Maynor的博客
07-25 4092
记录一下使用Hive的Bug Connection to node1.itcast.cn failed. [ 08S01] Could not open client transport with JDBC Uri: jdbc:hive2://192.168.88.10:10000: java.net.ConnectException: Connection refused: connect 结论:查网上资料说是jdbc驱动不匹配 然而也没找到相应的驱动 是通过换虚拟机解决的 mr执行太慢问题 set h
Error: Could not open client transport with JDBC Uri: jdbc:hive2://localhost
半壁江山009的博客
09-03 6829
解决方法： 这个问题还是数据库的问题，因为hive的元数据需要保存在自己配的mysql中或者他们数据库中 出现这个问题很大程度就是数据库出问题和hadoop没启动 所以： 1.查看自己的mysql（我存在mysql中） mysql -uroot -p enter password: 如果能正常登入 mysql&gt; 说明mysql没问题； 不能登入则先解决数据库问题 然后重启数...
Hive启动hiveserver2报错：Could not open client transport with JDBC Uri解决方案
热门推荐
zjh_746140129的博客
09-22 6万+
报错信息： Error: Could not open client transport with JDBC Uri: jdbc:hive2://node1:10000/hive_metadata;user=hadoop: java.net.ConnectException: 拒绝连接 (Connection refused) (state=08S01,code=0) Beeline vers...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值