How to execute jdbc interpreter jobs in specific yarn queue in Zeppelin

[#1]

Jdbc interpreter is will take default queue to run a job. 

To run the job in specific queue add the queue name in hive.url property in JDBC interpreter settings  as shown below

hive.url=jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=<Queue Name> 

EXAMPLE: 

hive.url= jdbc:hive2://c186-node2.-labs.com:2181,c186-node3.-labs.com:2181,c186-node4.-labs.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2?tez.queue.name=sai 

Where sai is my queue name.

To check and confirm execute below query in zeppelin using JDBC interpreter and check-in Yarn Resource manager UI

%jdbc(hive)
show databases;
use <database name>;
show tables;
select count (*) from <table name>;