Visit the official Paxata Documentation portal for all of your doc needs.

Use a specific queue for hive jobs from Hive jdbc.

How can Paxata be configured to use specific queue for hive jobs.

Problem: For every hive import, there is a map reduce , yarn application being submitted to hadoop cluster. These applications need to be submitted to a specific yarn queue.  Paxata auto generates the query for table import and submits to Hive Server. These queries would fail as there is no queue name specified.

Solution:
    In the hive jdbc URL configured inside connector or datasource , specify the queue name in JDBC URL.
   Below is sample.
jdbc:hive2://your.host:your.port/data_base?mapred.job.queue.name=your_queue_name





Sign In or Register to comment.