tHiveConnection with Cloudera: Submit Hive Queries to a specific Job queue

Question

How can I submit Hive Queries to a specific Job queue in tHiveConnection when using a Cloudera distribution?

 

Answer

This can be achieved by specifying the queue name in the JDBC parameter list.

Syntax:

jdbc:hive2://<host>:<port>/dbName;sess_var_list?mapred.job.queue.name=your_queue_name

 

So in Talend Studio, it can be specified as a property in the Additional JDBC settings on the tHive component.

 

connectionHive.png

 

Version history
Revision #:
3 of 3
Last update:
‎09-29-2018 12:16 AM
Updated by: