[ https://issues.apache.org/jira/browse/HIVE-13353?focusedWorklogId=818827&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-818827 ]
ASF GitHub Bot logged work on HIVE-13353: ----------------------------------------- Author: ASF GitHub Bot Created on: 20/Oct/22 14:57 Start Date: 20/Oct/22 14:57 Worklog Time Spent: 10m Work Description: deniskuzZ commented on code in PR #3608: URL: https://github.com/apache/hive/pull/3608#discussion_r1000750444 ########## parser/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g: ########## @@ -1334,7 +1336,12 @@ showStatement | (parttype=partTypeExpr)? (isExtended=KW_EXTENDED)? -> ^(TOK_SHOWLOCKS $parttype? $isExtended?) ) - | KW_SHOW KW_COMPACTIONS compactPool? -> ^(TOK_SHOW_COMPACTIONS compactPool?) + | KW_SHOW KW_COMPACTIONS Review Comment: we should also support ```` SHOW COMPACTIONS ID=xxx ```` Issue Time Tracking ------------------- Worklog Id: (was: 818827) Time Spent: 6.5h (was: 6h 20m) > SHOW COMPACTIONS should support filtering options > ------------------------------------------------- > > Key: HIVE-13353 > URL: https://issues.apache.org/jira/browse/HIVE-13353 > Project: Hive > Issue Type: Improvement > Components: Transactions > Affects Versions: 1.3.0, 2.0.0 > Reporter: Eugene Koifman > Assignee: KIRTI RUGE > Priority: Major > Labels: pull-request-available > Attachments: HIVE-13353.01.patch > > Time Spent: 6.5h > Remaining Estimate: 0h > > Since we now have historical information in SHOW COMPACTIONS the output can > easily become unwieldy. (e.g. 1000 partitions with 3 lines of history each) > this is a significant usability issue > Need to add ability to filter by db/table/partition > Perhaps would also be useful to filter by status -- This message was sent by Atlassian Jira (v8.20.10#820010)