Apache Hive - Required field 'client_protocol' is unset
Hello,
I have troubles setting up a Data source in PyCharm, using Apache Hive driver.
Hive 2.1.1 is installed on our server.
I use driver files provided by PyCharm, which states "ver. 3.1.1 [latest]"
When I set up the data source and test connection, I get the following error message:
[ 08S01] Could not open client transport with JDBC Uri: jdbc:hive2://...:10000: Could not establish connection to jdbc:hive2://...:10000: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{set:hiveconf:hive.server2.thrift.resultset.default.fetch.size=1000, use:database=default}) org.apache.hive.org.apache.thrift.TApplicationException: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{set:hiveconf:hive.server2.thrift.resultset.default.fetch.size=1000, use:database=default}).
Is this an incompatibility related to difference of versions between driver and server?
Thanks
Please sign in to leave a comment.
Yes it is jdbc driver incompatibility issue: https://youtrack.jetbrains.com/issue/DBE-8116
Please try using more recent version of the driver from https://github.com/timveil/hive-jdbc-uber-jar/releases or http://central.maven.org/maven2/org/apache/hive/hive-jdbc/ You can replace this driver in Hive driver settings that you use for this data source.