在启动beeline是报错WARN jdbc.HiveConnection: Failed to connect to hadoop102:10000Could not open connectio

Jorry_ Yxh

于 2024-04-14 17:51:25 发布

阅读量346

点赞数 2

文章标签： hadoop linux hive

本文链接：https://blog.csdn.net/Jorry_yuan/article/details/137750134

版权

WARN jdbc.HiveConnection: Failed to connect to hadoop102: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://hadoop102:10000: java.net.ConnectException: 拒绝连接 (Connection refused) (state=08S01,code=0)
Beeline version 3.1.2 by Apache Hive

我的原因是配置的hive-site.xml文件并没有在hadoop中生效-- 原因是hive依赖hadoop，但是hadoop的环境变量却没有读到hive-site.xml

解决办法:

在 etc/profile.d/my_env.sh

即环境变量的配置中加入

export HADOOP_CLASSPATH=$HIVE_HOME/conf:$HADOOP_CLASSPATH

其中$HIVE_HOME是你已经配置好的环境变量

再次启动beeline 问题解决

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

Jorry_ Yxh

关注关注

2
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
在启动beeline是报错WARN jdbc.HiveConnection: Failed to connect to hadoop102:10000Could not open connectio

我的原因是配置的hive-site.xml文件并没有在hadoop中生效-- 原因是hive依赖hadoop，但是hadoop的环境变量却没有读到hive-site.xml。在 etc/profile.d/my_env.sh。其中$HIVE_HOME是你已经配置好的环境变量。再次启动beeline 问题解决。即环境变量的配置中加入。
复制链接

扫一扫

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 作者：梁云亮

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

Without_1113的博客

07-01

1584

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.

1 条评论您还未登录，请先登录后发表或查看评论

Connecting to jdbc:hive2://bdc112:10000 21/12/19 21:05:23 [main]: WARN jdbc.HiveConnection: Failed t

qq_43224174的博客

12-19

1878

Connecting to jdbc:hive2://bdc112:10000 21/12/19 21:05:23 [main]: WARN jdbc.HiveConnection: Failed to connect to bdc112: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

Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000: Failed to open..

weixin_46005650的博客

04-10

8706

在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.

hadooop102连接不jdbc连接不上的时候出现的问题

热门推荐

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...

启动hiveserver2服务后使用beeline报错Could not open client transport with JDBC Uri: jdbc:hive2://localhost:100

Simon的博客

12-29

983

启动hive server2服务之后使用beeline链接报一下错误 beeline> !connect jdbc:hive2://localhost:10000 Connecting to jdbc:hive2://localhost:10000 Enter username for jdbc:hive2://localhost:10000: root Enter password for jdbc:hive2://localhost:10000: ** 19/03/01 22:01:59 [mai

大数据学习——hive阶段：启动HiveServer2启动报TezConfiguration类NoClassDefFoundError错误

m0_58310854的博客

03-03

1138

解决hiveserver2启动不成功问题

Hive初始化报错：org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver

zhengzaifeidelushang的博客

05-18

1万+

Hive初始化报错：org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver 完整错误如下所示： org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver Underlying cause: java.lang.ClassNotFoundException : com.mysql.jdbc.Driver Use --verbose

beeline> !connect jdbc:hive2://192.168.88.131:10000 -u root Connecting to jdbc:hive2://192.168.88.131:10000 23/06/08 18:05:24 [main]: WARN jdbc.HiveConnection: Failed to connect to 192.168.88.131: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.88.131:10000: java.net.ConnectException: 拒绝连接 (Connection refused) (state=08S01,code=0)

06-09

1. HiveServer2未启动或未启动成功。可以尝试在服务器上检查HiveServer2的日志文件，查看是否有任何错误或异常。 2. HiveServer2的地址或端口号不正确。请确保URI中的IP地址和端口号与HiveServer2的实际地址和端口...

beeline : Error: Could not open client transport with JDBC | datagrip UnknownHostException: xxxx连接失败

XIATWO

11-14

6550

报错信息 Error: Could not open client transport with JDBC Uri: jdbc:hive2://node01:10000: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0) 错误：无法打开具有JDBC Uri的客户端传输：JDBC:hive2://node01:10000:java.net.ConnectException:连接被

hive中 beeline连接时报错

qq_37668945的博客

11-01

2802

错误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....

beeline连接hive的hiveserver2报错

zhuyao3582的博客

06-27

3235

问题： Connecting to jdbc:hive2://hadoop102:10000 20/06/27 14:17:38 [main]: WARN jdbc.HiveConnection: Failed to connect to hadoop102:10000 Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask the admin

hive启动问题

weixin_43871309的博客

10-05

833

问题在启动hive链接beeline客户端时，无法连接，明明两个runjar都有了连接beeline失败： 21/10/05 20:44:29 [main]: WARN jdbc.HiveConnection: Failed to connect to hadoop102:10000 Could not open connection to the HS2 server. Please check the server URI and if the URI is correct, then ask t

Java连接hive报错01

北京小辉

06-03

5491

这个错误是hive的版本的包导致的。java.sql.SQLException: Could not establish connection to jdbc:hive2://hadoop2:10000/default: Required field 'serverProtocolVersion' is unset! Struct:TOpenSessionResp(status:TStatus(st

Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000

AlphaG的博客

11-07

3043

这个错误是在尝试使用jdbc访问hive的时候出现的问题报错如下解决过程涉及到hive-site.xml和core-site.xml 网上普遍的解决方法是： hive-site.xml新增配置 core-site.xml新增配置但是自己仍然不行，这时候需要在hive-site.xml里面新增一个如下内容，即可。成功页面 ...

Hive基础[Beeline连接hiveserver2报错 User: XXX is not allowed to impersonate XXX(YYY)]

weixin_43923463的博客

03-25

1275

报错信息 WARN jdbc.HiveConnection: Failed to connect to hadoop101:10000 Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop101:10000: Failed to oang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.autho