What is the table format? Different table formats require different amounts of memory to create the output HDFS file. Text and Sequencefiles need very little memory.
Hive copies data from table2 to a local files on some of the servers, then copies from those local files to the HDFS files in the output table. Hive stores nothing in memory.
I have never used Oozie. Does the Hive script do this when you run it from the HiveServer2 command line? Or from a JDBC client?
Follow. I have the similar issue