首页
学习
活动
专区
圈层
工具
发布
首页
学习
活动
专区
圈层
工具
MCP广场
社区首页 >问答首页 >beeline可以连接到jdbc:hive2://,但无法连接到jdbc:hive2://localhost:10000

beeline可以连接到jdbc:hive2://,但无法连接到jdbc:hive2://localhost:10000
EN

Stack Overflow用户
提问于 2021-06-15 05:13:43
回答 1查看 185关注 0票数 1

我正在为直接连接到配置单元服务器而挣扎。在我的服务器(名为Sun,此服务器上的所有操作)的hive文件夹中,我可以作为./bin/beeline启动beeline,然后连接到hive:!connect jdbc:hive2://,然后我成功地连接到我的hive,并且可以运行hive-sql语句。

但是,当我尝试./bin/beeline -u jdbc:hive2://localhost:10000 -n hive -p mypassword时,我无法直接连接到配置单元,并显示错误消息" error : can not open client transport with JDBC Uri: jdbc:hive2://localhost:10000“

我试着关注了许多帖子(例如beeline cannot connect to hive2serverConnecting to Hive using BeelineCannot connect to beeline hive2),但我仍然找不到解决方案。为什么我不能连接到localhost:10000 (或者是这台Sun机器的IP )?

有没有人知道我为什么会有这样的错误以及如何解决它?

代码语言:javascript
运行
复制
hadoop@Sun:/opt/apache-hive-3.1.2-bin$ ./bin/beeline
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/opt/apache-hive-3.1.2-bin/lib/log4j-slf4j-impl- 
2.10.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/lib/hadoop-3.2.2/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://
Connecting to jdbc:hive2://
Enter username for jdbc:hive2://: hive
Enter password for jdbc:hive2://: ****
21/06/14 23:02:10 [main]: WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
Hive Session ID = ae2fb753-de6d-4522-b128-770b1c358c8b
21/06/14 23:02:11 [main]: WARN session.SessionState: METASTORE_FILTER_HOOK will be ignored, since hive.security.authorization.manager is set to instance of HiveAuthorizerFactory.
Connected to: Apache Hive (version 3.1.2)
Driver: Hive JDBC (version 3.1.2)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://> show databases;
OK
+----------------+
| database_name  |
+----------------+
| default        |
| testwimp       |
| wimp           |
+----------------+
3 rows selected (1.978 seconds)
0: jdbc:hive2://> !connect jdbc:hive2://localhost:10000
Connecting to jdbc:hive2://localhost:10000
Enter username for jdbc:hive2://localhost:10000: hive
Enter password for jdbc:hive2://localhost:10000: ****
21/06/14 23:02:57 [main]: WARN jdbc.HiveConnection: Failed to connect to localhost: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://localhost:10000: java.net.ConnectException: Connection refused (Connection refused) (state=08S01,code=0)
0: jdbc:hive2://>
EN

回答 1

Stack Overflow用户

发布于 2021-06-15 17:27:13

这里有一个详细的答案:

https://www.programmersought.com/article/93495333620/

总之,check hiverserver2已启动,端口号10000已打开。

票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/67977287

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档