Java 连接hive2 server 通过jdbc 出现了问题 Required field 'client_protocol' is unset! Struct:TOpenSessionReq
来源:互联网 发布:java备忘录源码 编辑:程序博客网 时间:2024/06/06 00:55
/testjavaperl/lib/zookeeper-3.4.6.jar
May 05, 2016 8:53:26 AM org.apache.hive.jdbc.Utils parseURL
INFO: Supplied authorities: hdp-hiveserver-prd.app.paic.com.cn:10000
May 05, 2016 8:53:26 AM org.apache.hive.jdbc.Utils parseURL
INFO: Resolved authority: hdp-hiveserver-prd.app.paic.com.cn:10000
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
May 05, 2016 8:53:27 AM org.apache.hive.jdbc.HiveConnection openTransport
INFO: Will try to open client transport with JDBC Uri: jdbc:hive2://hdp-hiveserver-prd.app.paic.com.cn:10000
May 05, 2016 8:53:28 AM org.apache.hive.jdbc.HiveConnection openSession
SEVERE: Error opening session
org.apache.thrift.TApplicationException: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default})
at org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71)
at org.apache.hive.service.cli.thrift.TCLIService$Client.recv_OpenSession(TCLIService.java:156)
at org.apache.hive.service.cli.thrift.TCLIService$Client.OpenSession(TCLIService.java:143)
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:583)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:192)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at HiveJdbcJobTest.main(HiveJdbcJobTest.java:28)
Exception in thread "main" java.sql.SQLException: Could not establish connection to jdbc:hive2://hdp-hiveserver-prd.app.paic.com.cn:10000: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default})
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:594)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:192)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at HiveJdbcJobTest.main(HiveJdbcJobTest.java:28)
Caused by: org.apache.thrift.TApplicationException: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default})
at org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71)
at org.apache.hive.service.cli.thrift.TCLIService$Client.recv_OpenSession(TCLIService.java:156)
at org.apache.hive.service.cli.thrift.TCLIService$Client.OpenSession(TCLIService.java:143)
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:583)
May 05, 2016 8:53:26 AM org.apache.hive.jdbc.Utils parseURL
INFO: Supplied authorities: hdp-hiveserver-prd.app.paic.com.cn:10000
May 05, 2016 8:53:26 AM org.apache.hive.jdbc.Utils parseURL
INFO: Resolved authority: hdp-hiveserver-prd.app.paic.com.cn:10000
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
May 05, 2016 8:53:27 AM org.apache.hive.jdbc.HiveConnection openTransport
INFO: Will try to open client transport with JDBC Uri: jdbc:hive2://hdp-hiveserver-prd.app.paic.com.cn:10000
May 05, 2016 8:53:28 AM org.apache.hive.jdbc.HiveConnection openSession
SEVERE: Error opening session
org.apache.thrift.TApplicationException: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default})
at org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71)
at org.apache.hive.service.cli.thrift.TCLIService$Client.recv_OpenSession(TCLIService.java:156)
at org.apache.hive.service.cli.thrift.TCLIService$Client.OpenSession(TCLIService.java:143)
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:583)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:192)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at HiveJdbcJobTest.main(HiveJdbcJobTest.java:28)
Exception in thread "main" java.sql.SQLException: Could not establish connection to jdbc:hive2://hdp-hiveserver-prd.app.paic.com.cn:10000: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default})
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:594)
at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:192)
at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)
at java.sql.DriverManager.getConnection(DriverManager.java:571)
at java.sql.DriverManager.getConnection(DriverManager.java:215)
at HiveJdbcJobTest.main(HiveJdbcJobTest.java:28)
Caused by: org.apache.thrift.TApplicationException: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=default})
at org.apache.thrift.TApplicationException.read(TApplicationException.java:111)
at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:71)
at org.apache.hive.service.cli.thrift.TCLIService$Client.recv_OpenSession(TCLIService.java:156)
at org.apache.hive.service.cli.thrift.TCLIService$Client.OpenSession(TCLIService.java:143)
at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:583)
... 5 more
此问题时由于jdbc版本不对造成的,现给予相应的包版本如下:
hive-jdbc-0.13.1.jar(特别注意此版本)
hadoop-common-2.6.0-cdh5.4.2.jar
zookeeper-3.4.6.jar
slf4j-api-1.7.5.jar
libthrift-0.9.2.jar
httpcore-4.4.jar
httpclient-4.4.jar
hive-service-0.13.1.jar
hive-metastore-0.13.1.jar
hive-exec-0.13.1.jar
curator-client-2.6.0.jar
commons-logging-1.1.3.jar
curator-recipes-2.6.0.jar
curator-framework-2.6.0.jar
1 0
- Java 连接hive2 server 通过jdbc 出现了问题 Required field 'client_protocol' is unset! Struct:TOpenSessionReq
- 解决java使用jdbc连接hive2出现Required field 'client_protocol' is unset! Struct:TOpenSessionReq
- hive2中使用beeline:Required field 'serverProtocolVersion' is unset!
- Required field 'sessionHandle is unset !’
- Hive学习笔记 --- Required field 'sessionHandle' is unset! Struct:TExecuteStatementReq(sessionHan
- org.apache.thrift.protocol.TProtocolException: Required field 'sessionHandle' is unset! Struct:TExec
- java jdbc连接hive2
- Java JDBC方式连接HIVE2
- 解决JAVA通过JDBC连接Oracle数据库出现的问题
- JAVA通过JDBC连接SQL Server 2000
- java通过jdbc连接sql server 2008
- java通过jdbc连接sql server数据库
- 花了几个小时JDBC连接sql server 2012出现的异常com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 1433 ...解决了!
- 通过JDBC连接SQL Server
- SQL Server 连接JDBC时出现的问题
- java 通过jdbc连接sql server数据库的常见问题
- Eclipse中java通过JDBC连接Sql Server 2005
- Java工程通过JDBC连接数据库方法(SQL Server)
- dedecms织梦常见问题及处理方法
- leetcode笔记—翻转链表
- C#面向对象的概念
- Java设计代理模式之代理模式(Proxy Pattern)
- H.264学习历程
- Java 连接hive2 server 通过jdbc 出现了问题 Required field 'client_protocol' is unset! Struct:TOpenSessionReq
- 金融数据安全
- 本地文件多线程复制
- MySql trigger 触发器
- 一行代码实现java list去重
- Spring Boot中启动HTTPS
- js--异步编程的4种方法
- 如何上传织梦做的网站
- freemarker 内容