当前位置:   article > 正文

hive启动hiveserver2连JDBC报错:Could not open client transport with JDBC Uri解决方案_[ 08s01] could not open client transport with jdbc

[ 08s01] could not open client transport with jdbc uri: jdbc:hive2://hadoop0

开启hiveserver2和beeline后jdbc报错Could not open client transport with JDBC Uri

0: jdbc:hive2://hadoop100:10000(closed)> 

报错信息

  1. Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop100:10000/hive_metadata;user=hadoop: java.net.ConnectException: 拒绝连接 (Connection refused) (state=08S01,code=0)
  2. Beeline version 2.3.3 by Apache Hive

解决方案:

hadoop文件core-site.xml中配置信息如下,重启HDFS和Yarn,再次启动hiveserver2和beeline即可

  1. <property>
  2. <name>hadoop.proxyuser.hadoop.hosts</name>
  3. <value>*</value>
  4. </property>
  5. <property>
  6. <name>hadoop.proxyuser.hadoop.groups</name>
  7. <value>*</value>
  8. </property>

ok,hive的jdbc连接正常了

  1. beeline> !connect jdbc:hive2://hadoop100:10000
  2. Connecting to jdbc:hive2://hadoop100:10000
  3. Enter username for jdbc:hive2://hadoop100:10000: kevin
  4. Enter password for jdbc:hive2://hadoop100:10000:
  5. Connected to: Apache Hive (version 1.2.1)
  6. Driver: Hive JDBC (version 1.2.1)
  7. Transaction isolation: TRANSACTION_REPEATABLE_READ
  8. 0: jdbc:hive2://hadoop100:10000>

 

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/weixin_40725706/article/detail/424432
推荐阅读
相关标签
  

闽ICP备14008679号