[jira] [Work logged] (HIVE-25947) Compactor job queue cannot be set per table via compactor.mapred.job.queue.name

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-25947?focusedWorklogId=726616&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-726616 ]

ASF GitHub Bot logged work on HIVE-25947:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 14/Feb/22 21:40
            Start Date: 14/Feb/22 21:40
    Worklog Time Spent: 10m 
      Work Description: zabetak opened a new pull request #3027:
URL: https://github.com/apache/hive/pull/3027


   ### What changes were proposed in this pull request?
   Adapt the MR compactor to accept all the properties below:
   * compactor.mapred.job.queue.name
   * compactor.mapreduce.job.queuename
   * compactor.hive.compactor.job.queue
   
   for specifying the job queue per table and per compaction.
   
   Add unit tests defining and guarding the precedence among the aforementioned properties and the different granularity at which a queue can be defined.
   
   ### Why are the changes needed?
   The change restores backward compatibility and also enables the use of the non deprecated MR properties for specifying the job queue for every compaction.
   
   ### Does this PR introduce _any_ user-facing change?
   Yes, it restores the old functionality and defines the order on which properties should take effect.
   
   ### How was this patch tested?
   `mvn -pl ql test -Dtest=TestCompactorMRJobQueueConfiguration`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: gitbox-unsubscribe@hive.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 726616)
    Remaining Estimate: 0h
            Time Spent: 10m

> Compactor job queue cannot be set per table via compactor.mapred.job.queue.name
> -------------------------------------------------------------------------------
>
>                 Key: HIVE-25947
>                 URL: https://issues.apache.org/jira/browse/HIVE-25947
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>            Reporter: Stamatis Zampetakis
>            Assignee: Stamatis Zampetakis
>            Priority: Major
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Before HIVE-20723 it was possible to schedule the compaction for each table on specific job queues by putting {{compactor.mapred.job.queue.name}} in the table properties. 
> {code:sql}
> CREATE TABLE person (name STRING, age INT) STORED AS ORC TBLPROPERTIES(
> 'transactional'='true',
> 'compactor.mapred.job.queue.name'='root.user2);
> ALTER TABLE person COMPACT 'major' WITH OVERWRITE TBLPROPERTIES('compactor.mapred.job.queue.name'='root.user2')
> {code}
> This is no longer possible (after HIVE-20723) and in order to achieve the same effect someone needs to use the {{compactor.hive.compactor.job.queue}}.
> {code:sql}
> CREATE TABLE person (name STRING, age INT) STORED AS ORC TBLPROPERTIES(
> 'transactional'='true',
> 'compactor.hive.compactor.job.queue'='root.user2);
> ALTER TABLE person COMPACT 'major' WITH OVERWRITE TBLPROPERTIES('compactor.hive.compactor.job.queue'='root.user2')
> {code}



--
This message was sent by Atlassian Jira
(v8.20.1#820001)