HIVE Connection Error

[data_warrior]

Hi All,

I keep receiving the following error message when trying to query data from an ODBC Hive Connection.

Error SQLExtendedFetch: [Cloudera][Hardy] (35) Error from server: error code: '2' error message: Error while processing statement: FAILED: Execution error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedtask’

This is the logic I am using to try and pull the data.  When I test the query, "I receive a successful connection was made and no errors were found parsing the data".

Select rao_rao_applicationinfo.* From rao.rao_applicationinfo rao_rao_applicationinfo Where rao_rao_applicationinfo.pxcreatedatetime > '2021-09-19'

Can someone help me resolve this issue or provide advice on what I should do?

Thanks.

[jrgo]

Hi @data_warrior 

The error message was thrown from your DB; Alteryx just relayed the message to you. Googling that error does return some articles that may help to understand and troubleshoot the reason, but from the posts I saw, it seems that a bad document in the data store may be the issue.

https://stackoverflow.com/questions/11185528/what-is-hive-return-code-2-from-org-apache-hadoop-hive-...

https://community.cloudera.com/t5/Support-Questions/HIVE-return-code-2-from-org-apache-hadoop-hive-q...

You may need to consult your DB admin to help to diagnose depending on what permissions you have against the environment.