Community Articles

Find and share helpful community-sourced technical articles.
Labels (1)
avatar
Master Collaborator

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>;

 

 

627 Views