You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Stamatis Zampetakis (Jira)" <ji...@apache.org> on 2022/02/10 10:11:00 UTC

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

     [ https://issues.apache.org/jira/browse/HIVE-25947?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Stamatis Zampetakis reassigned HIVE-25947:
------------------------------------------


> 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
>
> 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)