[HIVE-12637] make retryable SQLExceptions in TxnHandler configurable

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 1.3.0, 2.1.0
• Component/s: Transactions
• Assignee: Wei Zheng
• Reporter: Eugene Koifman
• Created: 09/Dec/15 20:40
• Updated: 19/Aug/16 07:27
• Resolved: 25/Apr/16 18:22

Description

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

  private static String getMessage(SQLException ex) {
    return ex.getMessage() + "(SQLState=" + ex.getSQLState() + ",ErrorCode=" + ex.getErrorCode() + ")";
  }

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.