[ 
https://issues.apache.org/jira/browse/HIVE-26580?focusedWorklogId=821295&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-821295
 ]

ASF GitHub Bot logged work on HIVE-26580:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 28/Oct/22 06:29
            Start Date: 28/Oct/22 06:29
    Worklog Time Spent: 10m 
      Work Description: rkirtir commented on code in PR #3708:
URL: https://github.com/apache/hive/pull/3708#discussion_r1007689934


##########
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java:
##########
@@ -3881,15 +3881,18 @@ public boolean submitForCleanup(CompactionRequest rqst, 
long highestWriteId, lon
   public ShowCompactResponse showCompact(ShowCompactRequest rqst) throws 
MetaException {
     try {
       ShowCompactResponse response = new ShowCompactResponse(new 
ArrayList<>());
-      String query = TxnQueries.SHOW_COMPACTION_QUERY + 
getShowCompactFilterClause(rqst) + 
-        TxnQueries.SHOW_COMPACTION_ORDERBY_CLAUSE;
+      String query = TxnQueries.SHOW_COMPACTION_QUERY +
+        getShowCompactFilterClause(rqst) +
+        getShowCompactSortingOrderClause(rqst) ;
       List<String> params = getShowCompactParamList(rqst);
-

Review Comment:
   fixed





Issue Time Tracking
-------------------

    Worklog Id:     (was: 821295)
    Time Spent: 1h  (was: 50m)

> SHOW COMPACTIONS should support ordering and limiting functionality in 
> filtering options
> ----------------------------------------------------------------------------------------
>
>                 Key: HIVE-26580
>                 URL: https://issues.apache.org/jira/browse/HIVE-26580
>             Project: Hive
>          Issue Type: Improvement
>    Affects Versions: 3.0.0
>            Reporter: KIRTI RUGE
>            Assignee: KIRTI RUGE
>            Priority: Major
>              Labels: pull-request-available
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> SHOW COMPACTION should provide ordering by defied table . It should also 
> support limitation of fetched records



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to