@wert_1311 In CDP hive.server2.tez.initialize.default.sessions is set to true by default, that means when Hiveserver2 starts then applucation master also starts. By defalt the number of AM is 1, so the parallelism does not exists,one Tez job has to wait until other is finished.   Navigate to CM ==> Hive on Tez ==> COnfigs ==> Safety valve for Hiveserver2 hive-site.xml   Add hive.server2.tez.initialize.default.sessions= false   Restart and check   Please accept as SOlution, if the action plan has worked. ... View more

@Elbehwash    1. Please navigate to CM ==> Hive on tez ==>  COnfiguration ==> Hiveserver2 safety valve for hive-site.xml 2. Add      hive.server2.tez.initialize.default.sessions = false;   3. restart and check   ... View more

Please find the difference between hive.tez.container.size and tez.task.resource.mb   hive.tez.container.size This property specifies tez container size. Usually value of this property should be the same as or a small multiple (1 or 2 times that) of YARN container size yarn.scheduler.minimum-allocation-mb and should not exceed value of yarn.scheduler.maximum-allocation-mb. As a general rule don't put value higher than memory per processor as you want 1 processor per container and you want to spun up multiple containers. You can find very detailed answer and a great architecture diagram on Hortonworks community answer here tez.task.resource.memory.mb Amount of memory used by launched task in TEZ container. tez.task.resource.memory.mb should be set < hive.tez.container.size This will be recalculated. Run the job without setting.   ... View more