[hive] branch master updated: HIVE-27330: Compaction entry dequeue order (Laszlo Vegh, reviewed by Attila Turoczy, Zsolt Miskolczi, Kokila N, Krisztian Kasa)

[veghlaci05]

This is an automated email from the ASF dual-hosted git repository.

veghlaci05 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hive.git


The following commit(s) were added to refs/heads/master by this push:
     new 6efd81b0ae9 HIVE-27330: Compaction entry dequeue order (Laszlo Vegh, 
reviewed by Attila Turoczy, Zsolt Miskolczi, Kokila N, Krisztian Kasa)
6efd81b0ae9 is described below

commit 6efd81b0ae9c8eccce89fb3efb63dcaefb7d3054
Author: veghlaci05 <veghlac...@gmail.com>
AuthorDate: Wed May 17 11:35:05 2023 +0200

    HIVE-27330: Compaction entry dequeue order (Laszlo Vegh, reviewed by Attila 
Turoczy, Zsolt Miskolczi, Kokila N, Krisztian Kasa)
---
 .../java/org/apache/hadoop/hive/metastore/txn/CompactionTxnHandler.java  | 1 +
 1 file changed, 1 insertion(+)

diff --git 
a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/CompactionTxnHandler.java
 
b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/CompactionTxnHandler.java
index 5e3e31c1bc5..12240a3ac65 100644
--- 
a/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/CompactionTxnHandler.java
+++ 
b/standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/CompactionTxnHandler.java
@@ -258,6 +258,7 @@ class CompactionTxnHandler extends TxnHandler {
           sb.append("\"CQ_POOL_NAME\" IS NULL OR  \"CQ_ENQUEUE_TIME\" < (")
             .append(getEpochFn(dbProduct)).append(" - 
").append(poolTimeout).append(")");
         }
+        sb.append(" ORDER BY \"CQ_ID\" ASC");
         String query = sb.toString();
         stmt = dbConn.prepareStatement(query);
         if (hasPoolName) {