[HIVE-27555] Upgrade issues with Kudu table on backend db

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 4.0.0-beta-1
• Fix Version/s: 4.0.0
• Labels: hive-4.0.0-must pull-request-available
• Assignee: Zhihua Deng
• Reporter: Zhihua Deng
• Created: 01/Aug/23 12:31
• Updated: 04/Jun/24 12:28
• Resolved: 09/Dec/23 10:11

Description

In HIVE-27457, we try to update the serde lib, (input/output)format of the kudu table in back db. In the upgrade scripts, we join the  "SDS"."SD_ID" with "TABLE_PARAMS"."TBL_ID", 

https://github.com/apache/hive/blob/master/standalone-metastore/metastore-server/src/main/sql/mysql/upgrade-4.0.0-alpha-2-to-4.0.0-beta-1.mysql.sql#L37-L39

as "SD_ID" is the primary key of SDS, and "TBL_ID" is the primary key of TBLS, we can't join the two tables using these two columns.

Issue Links

• duplicates: HIVE-28263 Metastore scripts : Update query getting stuck when sub-query of in-clause is returning empty results
• links to: GitHub Pull Request #4872