belugabehr commented on a change in pull request #2274:
URL: https://github.com/apache/hive/pull/2274#discussion_r637097800
##########
File path:
standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/CompactionTxnHandler.java
##########
@@ -305,16 +302,19 @@ public void markCompacted(CompactionInfo info) throws
MetaException {
* By filtering on minOpenTxnWaterMark, we will only cleanup after
every transaction is committed, that could see
* the uncompacted deltas. This way the cleaner can clean up
everything that was made obsolete by this compaction.
*/
- String s = "SELECT \"CQ_ID\", \"CQ_DATABASE\", \"CQ_TABLE\",
\"CQ_PARTITION\", "
- + "\"CQ_TYPE\", \"CQ_RUN_AS\", \"CQ_HIGHEST_WRITE_ID\" FROM
\"COMPACTION_QUEUE\" WHERE \"CQ_STATE\" = '"
- + READY_FOR_CLEANING + "'";
- if (minOpenTxnWaterMark > 0) {
- s = s + " AND (\"CQ_NEXT_TXN_ID\" <= " + minOpenTxnWaterMark + " OR
\"CQ_NEXT_TXN_ID\" IS NULL)";
- }
+ String s = "SELECT \"CQ_ID\", \"CQ_DATABASE\", \"CQ_TABLE\",
\"CQ_PARTITION\", \"CQ_TYPE\", \"CQ_RUN_AS\"," +
+ " \"CQ_HIGHEST_WRITE_ID\", \"CQ_NEXT_TXN_ID\" FROM
\"COMPACTION_QUEUE\" WHERE \"CQ_ID\" IN (" +
+ " SELECT DISTINCT \"CQ_ID\" FROM (" +
+ " SELECT MAX(\"CQ_NEXT_TXN_ID\") \"CQ_NEXT_TXN_ID\",
MAX(\"CQ_ID\") \"CQ_ID\" " +
+ " FROM \"COMPACTION_QUEUE\" WHERE \"CQ_STATE\" = '" +
READY_FOR_CLEANING + "'" +
+ " AND (\"CQ_NEXT_TXN_ID\" <= "+ minOpenTxnWaterMark + " OR
\"CQ_NEXT_TXN_ID\" IS NULL)";
if (retentionTime > 0) {
- s = s + " AND \"CQ_COMMIT_TIME\" < (" + getEpochFn(dbProduct) + " -
" + retentionTime + ")";
+ s += " AND \"CQ_COMMIT_TIME\" < (" + getEpochFn(dbProduct) + "
- " + retentionTime + ")";
+ }
+ s += " GROUP BY \"CQ_DATABASE\", \"CQ_TABLE\", \"CQ_PARTITION\"
) \"X\" )";
+ if (LOG.isDebugEnabled()) {
+ LOG.debug("Going to execute query <" + s + ">");
Review comment:
`LOG.debug("Going to... <{}>", s);`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org
