deniskuzZ commented on code in PR #3576: URL: https://github.com/apache/hive/pull/3576#discussion_r1118775359
########## standalone-metastore/metastore-server/src/main/java/org/apache/hadoop/hive/metastore/txn/TxnHandler.java: ########## @@ -5894,6 +5902,63 @@ private void addTxnToMinHistoryLevel(Connection dbConn, List<Long> txnIds, long } } + @Override + @RetrySemantics.SafeToRetry + public void addWriteIdsToMinHistory(long txnid, Map<String, Long> minOpenWriteIds) throws MetaException { + if (!useMinHistoryWriteId) { + return; + } + // Need to register minimum open writeId for current transactions into MIN_HISTORY_WRITE_ID table. + try { + Connection dbConn = null; + try { + dbConn = getDbConn(Connection.TRANSACTION_READ_COMMITTED); + try (PreparedStatement pstmt = dbConn.prepareStatement(MIN_HISTORY_WRITE_ID_INSERT_QUERY)) { + int writeId = 0; + + for (Map.Entry<String, Long> validWriteId : minOpenWriteIds.entrySet()) { + String[] names = TxnUtils.getDbTableName(validWriteId.getKey()); + + pstmt.setLong(1, txnid); + pstmt.setString(2, names[0]); + pstmt.setString(3, names[1]); + pstmt.setLong(4, validWriteId.getValue()); + + pstmt.addBatch(); + writeId++; + if (writeId % maxBatchSize == 0) { + LOG.debug("Executing a batch of <" + TXN_TO_WRITE_ID_INSERT_QUERY + "> queries. " + + "Batch size: " + maxBatchSize); + pstmt.executeBatch(); + } + } + if (writeId % maxBatchSize != 0) { + LOG.debug("Executing a batch of <" + TXN_TO_WRITE_ID_INSERT_QUERY + "> queries. " + + "Batch size: " + writeId % maxBatchSize); + pstmt.executeBatch(); + } + } Review Comment: that would be a massive refactor of TxnHandler -- 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. To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org 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