I am trying to understand how does hive insert into with select works at memory and storage level. One of my oozie workflow fails due to GC overhead issue. Our query is: insert into table <> select a,b,c,d from table2. Now the map reduce job finished and then we get the message : Ended job = jobid: <> Loading data to table table2  Failed with exception java.lang.outofmemoryError: G…