Set hive.fetch.task.conversion=none on HIVE query

[Jellykun]

I got the follow error querying data in HIVE.   Does anyone know where this should be set?

data volume is large, for now, I am limiting # of records to pull in my query so I can continue to test Alteryx.

Input Data (1)    Error SQLExtendedFetch: [Cloudera][Hardy] (35) Error from server: error code: '0' error message: 'java.io.IOException: Time limit exceeded for local fetch task with SimpleFetchOptimization. Please rerun with hive.fetch.task.conversion=none'.

[patrick_mcauliffe · Accepted solution]

That's in your ODBC settings.
Open the ODBC Administrator (Win key --> ODBC).

You may need to use the Run as Admin when opening the ODBC Admin.

Locate the specific Hive entry used for this DSN.

Click on the Hive entry, then the configure button.

On the bottom of the next screen there should be an Advanced button, then within that window, click the "Server Side Properties".  In here, click Add.

Everything before the "=" is the key.  Everything after the "=" (in this case "none") is  the value.

[Jellykun · Accepted solution]

Thank you it worked.  I am able to fetch the table with entire data.