@Tomomichi Hirano: Is this what you are looking for? https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_command-line-installation/content/ch09s15s02.html ... View more

@Harish Nerella If a table is to be used in ACID writes (insert, update, delete) then the table property "transactional=true" must be set on that table.Also, hive.txn.manager must be set to org.apache.hadoop.hive.ql.lockmgr.DbTxnManager either in hive-site.xml or in the beginning of the session before any query is run. Refer https://cwiki.apache.org/confluence/display/Hive/Hive+Transactions for more details. ... View more

@Greg Keys Yes. You are right. The JDBC URL for LLAP is same in HDP 2.5 and 2.6. And yes Hiveserver2 port is 10000 and LLAP port is 10500 ... View more

@Guillaume Roger Hoping the attached link will help:- https://community.hortonworks.com/articles/14309/demystify-tez-tuning-step-by-step.html ... View more

@Guillaume Roger If AM memory (tez-site/tez.am.resource.memory.mb) is set to the min container size, only 1 application can be launched at any given point of time. Please tune the property depending on your requirement . ... View more

@Guillaume Roger: The issue seems to be happening as the maximum application master limit has been set to 20%. Maximum percent of resources in the cluster which can be used to run application masters - controls number of concurrent active applications. Limits on each queue are directly proportional to their queue capacities and user limits. Since the limit here has been reached, I guess the application is not able to spawn another application master and hence the query is not running. Can we try increasing the parameter yarn.scheduler.capacity.maximum-am-resource-percent / yarn.scheduler.capacity.<queue-path>.maximum-am-resource-percent to 35% and see if it resolves the issue? ... View more

@Aditya Pratap: Please accept the answer if it solved your problem ... View more