Hi@Sagar Morakhia currently no other job are running except this job,actually it was stuck at 97.22% and when i kill the job and rerun again it was stuck same position , last reducer was running forever. up to table creation and insert the values into drome_master_5 it was good but while insert value into .drome_master_6 it was stuck. below is step where the query stuck insert into table dropme_master_6 select * from dropme_master_5 where dropme_master_5.consumer_sequence_id not in ( select consumer_sequence_id from dropme_master_6); and while executing the this step it shows below warning message Warning: Map Join MAPJOIN[30][bigTable=dropme_master_5] in task 'Map 4' is a cross product i was split query and execute it like below and it gave result very fast select count(consumer_sequence_id) from dropme_master_6; result:10352059 select count(*) from dropme_master_5; OK 21287539 i have added below parameter to the job but no use set hive.execution.engine=mr; set hive.vectorized.execution.enabled = true; set hive.vectorized.execution.reduce.enabled = true; set hive.tez.container.size=10240; set hive.tez.java.opts=-Xmx9216m; set mapreduce.map.memory.mb=8192; set mapreduce.map.java.opts=-Xmx7372m; set mapreduce.reduce.memory.mb=9216; set mapreduce.reduce.java.opts=-Xmx8294m; set yarn.scheduler.minimum-allocation-mb=1024; set yarn.scheduler.maximun-allocation-mb=11264; set hive.cbo.enable=true; cluster-status.png job-status.png ... View more

Thanks you so much @mqureshi I could not find mapreduce.task.files.preserve.failedtasks , i am using MRv2 HDP 2.1.3 and currently i dont have running jobs.. ... View more

@Jay SenSharma Thanks its working fine warning masg are not coming .. ... View more

Thank you so much@Jay SenSharma what are step should i follow after restart the ambari? can you suggest any document which help me step by step? ... View more

Thanks @Jay SenSharma Yes i have not found files-2.2.2.xxx.jar -rw-r--r-- 1 root root 571873 Jul 12 2016 ambari-admin-2.2.1.12.4.jar -rw-r--r-- 1 root root 45379969 Jul 12 2016 capacity-scheduler-2.2.1.12.4.jar -rw-r--r-- 1 root root 98659271 Jul 12 2016 hive-2.2.1.12.4.jar -rw-r--r-- 1 root root 46912006 Jul 12 2016 pig-2.2.1.12.4.jar -rw-r--r-- 1 root root 52241298 Jul 12 2016 slider-2.2.1.12.4.jar -rw-r--r-- 1 root root 48027227 Jul 12 2016 tez-view-2.2.1.12.4.jar drwxr-xr-x 8 root root 4096 Aug 5 2016 work how could i add the jar file here? ... View more

Thanks for quick response@Ravi Mutyala But here my concern i could not see any FILE View instance to expand,How to enable this? Browse to the Ambari Administration interface. Click Views, expand the Files View, and click Create Instance. ... View more