ERROR jdbc.HiveConnection: Error opening session Hive

java hadoop jdbc hive

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)

This error mostly occurs if you have version mismatch between your hive and hive-jdbc. Please check if both the versions match.

Please refer this for more information.

java hadoop jdbc hive

This happens when a new version of JDBC driver is used against older version of HiveServer2.Use a jdbc driver that is same version as server (preferred), or an version that is older than the server.

The issue is tracked in https://issues.apache.org/jira/browse/HIVE-6050

java hadoop jdbc hive

"client_protocol" field is available in hive 1.1 version.You need to add hive-service-1.1.0.jar in classpath.

I hope your problem would get solved.

CodeHunter

ERROR jdbc.HiveConnection: Error opening session Hive

Recent Posts

How can I color dots in a xy scatterplot according to column value?

How to update a claim in ASP.NET Identity?

What does {0} mean when initializing an object?

Accessing members of items in a JSONArray with Java

How to log SQL statements in Spring Boot?

Powershell Get-WebSite name parameter is ignored

How to detect scroll to bottom of html element

Java synchronized method

How to test controllers with CodeIgniter?

Detect Visual Composer

Matplotlib: Specify format of floats for tick labels

Rails join a list of strings with commas and "and" before the last