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