Support Questions

Find answers, ask questions, and share your expertise

Who agreed with this solution

avatar
Master Guru
@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_guide...

View solution in original post

Who agreed with this solution