You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Karen Coppage (Jira)" <ji...@apache.org> on 2021/11/08 10:47:00 UTC
[jira] [Commented] (HIVE-25672) Hive isn't purging older compaction
entries from show compaction command
[ https://issues.apache.org/jira/browse/HIVE-25672?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17440396#comment-17440396 ]
Karen Coppage commented on HIVE-25672:
--------------------------------------
Make sure the AcidHouseKeeperService is running: hive.metastore.housekeeping.threads.on=true.
Does this fix the issue?
> Hive isn't purging older compaction entries from show compaction command
> ------------------------------------------------------------------------
>
> Key: HIVE-25672
> URL: https://issues.apache.org/jira/browse/HIVE-25672
> Project: Hive
> Issue Type: Bug
> Components: Hive, Metastore, Transactions
> Affects Versions: 3.1.1
> Reporter: Rohan Nimmagadda
> Priority: Minor
>
> Added below properties in hive-site, but it's not enforced to auto purging.
> When we run show compaction command it takes forever and returns billions of rows.
> Result of show compactions command :
> {code:java}
> 752,450 rows selected (198.066 seconds)
> {code}
> {code:java}
> hive.compactor.history.retention.succeeded": "10",
> "hive.compactor.history.retention.failed": "10", "hive.compactor.history.retention.attempted": "10", "hive.compactor.history.reaper.interval": "10m" {code}
--
This message was sent by Atlassian Jira
(v8.20.1#820001)