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