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

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_r1007689626


##########
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java:
##########
@@ -4013,6 +4016,12 @@ private String 
getShowCompactFilterClause(ShowCompactRequest request) {
       " WHERE " + StringUtils.join(" AND ", params) : EMPTY;
   }
 
+  private String getShowCompactSortingOrderClause(ShowCompactRequest request){
+   String sortingOrder = request.getOrder();
+   return  isNotBlank(sortingOrder) ? 
TxnQueries.SHOW_COMPACTION_ORDERBY_CLAUSE + " , " + sortingOrder :

Review Comment:
   fixed





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

    Worklog Id:     (was: 821294)
    Time Spent: 50m  (was: 40m)

> 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: 50m
>  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