question Re: ODBC Driver - Error when joining tables in Archives of Support Questions (Read Only)

ODBC Driver - Error when joining tables

cwebb — Thu, 19 May 2016 18:02:01 GMT

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?

Re: ODBC Driver - Error when joining tables

Boris G — Thu, 26 May 2016 17:55:49 GMT

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.

Re: ODBC Driver - Error when joining tables

cwebb — Thu, 02 Jun 2016 17:30:25 GMT

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