赞
踩
开启hiveserver2和beeline后jdbc报错Could not open client transport with JDBC Uri
0: jdbc:hive2://hadoop100:10000(closed)>
报错信息
- 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)
- Beeline version 2.3.3 by Apache Hive
解决方案:
在hadoop文件core-site.xml中配置信息如下,重启HDFS和Yarn,再次启动hiveserver2和beeline即可
- <property>
- <name>hadoop.proxyuser.hadoop.hosts</name>
- <value>*</value>
- </property>
- <property>
- <name>hadoop.proxyuser.hadoop.groups</name>
- <value>*</value>
- </property>
ok,hive的jdbc连接正常了
- beeline> !connect jdbc:hive2://hadoop100:10000
- Connecting to jdbc:hive2://hadoop100:10000
- Enter username for jdbc:hive2://hadoop100:10000: kevin
- Enter password for jdbc:hive2://hadoop100:10000:
- Connected to: Apache Hive (version 1.2.1)
- Driver: Hive JDBC (version 1.2.1)
- Transaction isolation: TRANSACTION_REPEATABLE_READ
- 0: jdbc:hive2://hadoop100:10000>
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。