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

[Stamatis Zampetakis (Jira)]

Stamatis Zampetakis created HIVE-25947:
------------------------------------------

             Summary: 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


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)