이야기박스
java jdbc hive connection 이슈 본문
반응형
커넥션 테스트 하는 중, 에러 발생
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://${uri}: Could not establish connection to jdbc:hive2://${uri}: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{set:hiveconf:hive.server2.thrift.resultset.default.fetch.size=1000, use:database=${db}})
hive-jdbc 버전 문제라는 이야기가 있음
As is --> 2.3.4 version
To be --> 2.1.0 version
그대로 발생
....
to be.. to be... ==> 1.2.1 version --> ok
1.2.1 버전까지 낮추니까 됨..
<dependency>
<groupId>org.apache.hive</groupId>
<artifactId>hive-jdbc</artifactId>
<!--<version>${hive.version}</version>-->
<version>1.2.1</version>
</dependency>
반응형
'Computer & Data > Big Data' 카테고리의 다른 글
hive orc 안써짐 (1) | 2018.12.14 |
---|---|
hive query 에러 (0) | 2018.12.14 |
[MariaDB] errno: 150 "Foreign key constraint is incorrectly formed" (1) | 2018.12.11 |
What is ORC File Format? (0) | 2018.12.05 |
Nomalization (정규화) (0) | 2018.10.25 |