[jira] [Updated] (HIVE-12637) make retryable SQLExceptions in TxnHandler configurable

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

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

Eugene Koifman updated HIVE-12637:
----------------------------------
    Target Version/s: 1.3.0, 2.1.0

> make retryable SQLExceptions in TxnHandler configurable
> -------------------------------------------------------
>
>                 Key: HIVE-12637
>                 URL: https://issues.apache.org/jira/browse/HIVE-12637
>             Project: Hive
>          Issue Type: Improvement
>          Components: Transactions
>    Affects Versions: 1.0.0
>            Reporter: Eugene Koifman
>            Assignee: Eugene Koifman
>
> same for CompactionTxnHandler
> would be convenient if the user could specify some RegEx (perhaps by db type) which will tell TxnHandler.checkRetryable() that this is should be retried.
> The regex should probably apply to String produced by 
> {noformat}
>   private static String getMessage(SQLException ex) {
>     return ex.getMessage() + "(SQLState=" + ex.getSQLState() + ",ErrorCode=" + ex.getErrorCode() + ")";
>   }
> {noformat}
> This make it flexible.
> See if we need to add Db type (and possibly version) of the DB being used.
> With 5 different DBs supported this gives control end users.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)