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

Reply via email to