[
https://issues.apache.org/jira/browse/HIVE-12439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eugene Koifman updated HIVE-12439:
----------------------------------
Description:
# add distinct to s = "select txn_id from TXNS, TXN_COMPONENTS where txn_id =
tc_txnid and txn_state = '" +
TXN_ABORTED + "' and tc_database = '" + info.dbname + "' and
tc_table = '" +
# add a safeguard to make sure IN clause is not too large; break up by txn id
to delete from TXN_COMPONENTS where tc_txnid in ...
# TxnHandler. openTxns() - use 1 insert with many rows in values() clause,
rather than 1 DB roundtrip per row
was:
# add distinct to s = "select txn_id from TXNS, TXN_COMPONENTS where txn_id =
tc_txnid and txn_state = '" +
TXN_ABORTED + "' and tc_database = '" + info.dbname + "' and
tc_table = '" +
# add a safeguard to make sure IN clause is not too large; break up by txn id
to delete from TXN_COMPONENTS where tc_txnid in ...
> CompactionTxnHandler.markCleaned() add safety guards
> ----------------------------------------------------
>
> Key: HIVE-12439
> URL: https://issues.apache.org/jira/browse/HIVE-12439
> Project: Hive
> Issue Type: Bug
> Components: Metastore, Transactions
> Affects Versions: 1.0.0
> Reporter: Eugene Koifman
> Assignee: Eugene Koifman
>
> # add distinct to s = "select txn_id from TXNS, TXN_COMPONENTS where txn_id =
> tc_txnid and txn_state = '" +
> TXN_ABORTED + "' and tc_database = '" + info.dbname + "' and
> tc_table = '" +
> # add a safeguard to make sure IN clause is not too large; break up by txn id
> to delete from TXN_COMPONENTS where tc_txnid in ...
> # TxnHandler. openTxns() - use 1 insert with many rows in values() clause,
> rather than 1 DB roundtrip per row
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
