이야기박스

java jdbc hive connection 이슈 본문

Computer & Data/Big Data

java jdbc hive connection 이슈

박스님 2018. 12. 14. 15:19
반응형

커넥션 테스트 하는 중, 에러 발생


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