ODBC Driver - Error when joining tables

[#1]

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?

[#2]

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.

[#3 · Accepted solution]

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