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