Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (1)
Expert Contributor

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.squadron-labs.com:2181,c186-node3.squadron-labs.com:2181,c186-node4.squadron-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>;

 

66 Views
Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
1 of 1
Last update:
‎09-04-2019 10:28 AM
Updated by:
 
Contributors
Top Kudoed Authors