How to assign a queue name to a Hive connection in TIBCO Data Virtualization?
Article ID: KB0072108
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | All supported versions |
Description
This article explains the steps to follow to assign a queue name to a Hive connection in TIBCO Data Virtualization.
Issue/Introduction
How to assign a queue name to a Hive connection in TIBCO Data Virtualization?
Resolution
1. In TDV Studio, open the Hive data source.
2. Navigate to the 'Advanced tab' and edit the 'Connection URL pattern' as below to include the queue name.
Connection URL Pattern: jdbc:hive2://<HOST>:<PORT>/<DATABASE_NAME>?mapreduce.job.queuename=<enter_the_name_of_queue>
Example of the 'Connection URL pattern' with the queue name: jdbc:hive2://<HOST>:<PORT>/<DATABASE_NAME>?mapreduce.job.queuename=q1.queue123
3. Save this change.
4. Close and open the data source for the change to reflect in the 'Connection URL String'
Example of the 'Connection URL String': jdbc:hive2://hive123.abc.com:10305/sch_db_stg?mapreduce.job.queuename=q1.queue123
2. Navigate to the 'Advanced tab' and edit the 'Connection URL pattern' as below to include the queue name.
Connection URL Pattern: jdbc:hive2://<HOST>:<PORT>/<DATABASE_NAME>?mapreduce.job.queuename=<enter_the_name_of_queue>
Example of the 'Connection URL pattern' with the queue name: jdbc:hive2://<HOST>:<PORT>/<DATABASE_NAME>?mapreduce.job.queuename=q1.queue123
3. Save this change.
4. Close and open the data source for the change to reflect in the 'Connection URL String'
Example of the 'Connection URL String': jdbc:hive2://hive123.abc.com:10305/sch_db_stg?mapreduce.job.queuename=q1.queue123
Feedback
Yes
No
Powered by
