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.
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.
You may need to consult your DB admin to help to diagnose depending on what permissions you have against the environment.