ERROR : FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
Unfortunately, Hive doesn't give much to the end user/client in terms of helpful error messages. Could you include the logs from the Hive Server, as well as the logs from any failed Map/Reduce jobs that you are seeing when you run your Hive query? That should be where the important bits are for diagnosing the issue at hand.