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 #:
2 of 2
Last update:
‎01-22-2018 04:51 PM
Updated by: