Home Admin Corner

Paxata Community Members: Something special in a community experience is coming your way. Stay tuned to this space.
In the meantime, check out the brand new Data Prep for Data Science topic here and the new DataRobot Community.

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.