Hi,

Error related to "MapredLocalTask"+"hive.auto.convert.join" has a lot to do with the JVM Heap Size.

If you run the query against the hive cli, you should try to increase the JVM Heap size of the HIVE Gateway.
If you run the query against HUE (or using a JDBC connection), you should try to increase the JVM Heap size of the HiveServer2.

Good luck.