@Sunile Manjee If you are using MR as execution engine then this command is fine. If you are using TEZ then I believe you can use below command beeline !connect jdbc:hive2://your.host:your.port/data_base?tez.queue.name=<queue-name> Additionally If you want to set one dedicated queue for hive jobs then you can modify tez.queue.name property via Ambari. There is an option of interactive queues as well if you want to use multiple dedicated queues for hive. Please see this - https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_performance_tuning/content/section_guidelines_for_interactive_queues.html ... View more

@Saurabh Kumar Please have a look at below documents, this information is useful for recovery https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.4/bk_upgrading_hdp_manually/content/configure-yarn-mr-22.html https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_upgrading_hdp_manually/content/start-webhcat-20.html https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.2/bk_upgrading_hdp_manually/content/start-tez-22.html https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.0/bk_installing_manually_book/content/upload_pig_hive_sqoop_tarballs_to_hdfs.html ... View more