Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

ODBC Driver - Error when joining tables

New Contributor

I have the Cloudera ODBC driver installed on my machine (v2.5.19.1004).  

 

I receive the following error when I execute a query that joins two tables together

 

Error from server: error code: '0' error message: 'ExecuteStatement finished with operation state: ERROR_STATE

I can query each table individually without error.  It is only when I join them together do I get this error. Any thoughts on what the problem could be?

1 ACCEPTED SOLUTION

New Contributor

I worked with Cloudera support and they found a solution

 

The issue

This issue is caused by the HiveServer2 failing to execute a MapReduce Local Task and it does not seem bound to queries submitted through ODBC

 

The solution

In the ODBC properties I set hive.auto.convert.join to false

 

View solution in original post

2 REPLIES 2

Cloudera Employee

Hi,

 

Probably, you need to try the same operation from beeline. If that works then ODBC needs tuning. If not -- then your query needs tuning.

New Contributor

I worked with Cloudera support and they found a solution

 

The issue

This issue is caused by the HiveServer2 failing to execute a MapReduce Local Task and it does not seem bound to queries submitted through ODBC

 

The solution

In the ODBC properties I set hive.auto.convert.join to false