Try to minimize the batches you insert, you can do it either; 1- insert range of partitions, by using where clause  For example assuming table partioned by date; INSERT OVERWRITE TABLE t1 partition(`date`) SELECT * FROM t2 WHERE `date` BETWEEN date1 AND date2   2- Or you can create a bash loop over the partitions to insert a partition each time. using show partitions command     ... View more