[jira] [Updated] (HIVE-12439) CompactionTxnHandler.markCleaned() and TxnHandler.openTxns() misc improvements

["Eugene Koifman (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-12439?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eugene Koifman updated HIVE-12439:
----------------------------------
    Description: 

# 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 ...

# TxnHandler. openTxns() - use 1 insert with many rows in values() clause, rather than 1 DB roundtrip per row


> CompactionTxnHandler.markCleaned() and TxnHandler.openTxns() misc improvements
> ------------------------------------------------------------------------------
>
>                 Key: HIVE-12439
>                 URL: https://issues.apache.org/jira/browse/HIVE-12439
>             Project: Hive
>          Issue Type: Improvement
>          Components: Metastore, Transactions
>    Affects Versions: 1.0.0
>            Reporter: Eugene Koifman
>            Assignee: Eugene Koifman
>
> # 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)