[HIVE-24796] [HS2] Enhance DriverTxnHandler.isValidTxnListState logic to include tableId comparison

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Component/s: HiveServer2
• Assignee: Kishen Das Assign to me
• Reporter: Kishen Das
• Created: 18/Feb/21 18:41
• Updated: 18/Mar/21 16:49
• Resolved: 18/Mar/21 16:49

Description

In HS2, after query compilation phase, we acquire lock in DriverTxnHandler.

isValidTxnListState and later ensure there are no conflicting transactions by using driverContext.getTxnManager().getLatestTxnIdInConflict(); . This doesn't work well, if there are external entities that drop and recreate the table with the same name. So, we should also make sure the tableId itself is not changed, after lock has been acquired. This Jira is to enhance the DriverTxnHandler.isValidTxnListState logic to include tableId comparison.