03-26-2015 09:09 AM
I am running a query in Hive from Hue. When running a query "select * from abc", I get the results.
However when I run a query "select count(*) from abc", I get an error
"Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask"
It seems, it is not able to run MapReduce tasks.
Any settings which need to be examined for this?
03-26-2015 12:28 PM
On further analysis, we found that the error actually related to memory -
InvalidResourceRequestException Invalid resource request,
requested memory < 0, or requested memory > max configured,
We looked through various sites and changed the Yarn configuration at 2 places -
Cloudera Manager --> Yarn --> Configuration
1) Search for "yarn-site"
At the Yarn Service Advanced Configuration Snippet, add a safety valve as follows
2) Search for "yarn_nodemanager_resource"
Change Container Memory at both places to default value of 8 GB
We restarted the cluster and deployed the new configuration and Hive queries started running from command line interface.
However, I am unable to run them through Hue. Get an error "Unmanageable server error occured: undefined". Not sure if the above changes are the cause of this error.