[
https://issues.apache.org/jira/browse/HIVE-28442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Butao Zhang resolved HIVE-28442.
--------------------------------
Fix Version/s: 4.1.0
Resolution: Fixed
Merged into master branch!
Thanks [~Indhumathi27] for the patch!
Thanks [~kokila19] for the review!
> Inconsistency in schema on tables TAB_COL_STATS, PART_COL_STATS,
> KEY_CONSTRAINTS and SCHEDULED_QUERIES on SYSDB after upgrade from 3.1.0 to
> 4.1.0
> -------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-28442
> URL: https://issues.apache.org/jira/browse/HIVE-28442
> Project: Hive
> Issue Type: Bug
> Reporter: Indhumathi Muthumurugesh
> Assignee: Indhumathi Muthumurugesh
> Priority: Major
> Labels: pull-request-available
> Fix For: 4.1.0
>
> Attachments: image-2024-08-12-13-22-25-517.png,
> image-2024-08-12-13-23-29-221.png, image-2024-08-12-13-24-29-328.png,
> image-2024-08-12-13-25-25-731.png, image-2024-08-14-18-59-57-815.png,
> image-2024-08-14-19-00-30-680.png, image-2024-08-14-19-04-16-332.png,
> image-2024-08-14-19-04-55-550.png
>
>
> Fresh Install: InitSchema
> *1. Tables SYSDB.TAB_COL_STATS and SYSDB.PART_COL_STATS*
> !image-2024-08-12-13-22-25-517.png|width=399,height=241!
> Select * from the above tables:
> !image-2024-08-12-13-23-29-221.png|width=439,height=265!
>
> Upgrade Hive Schema from 3.2.0 to 4.1.0:
> !image-2024-08-12-13-24-29-328.png|width=466,height=285!
> Select * on the tables fails post upgrade
> !image-2024-08-12-13-25-25-731.png|width=416,height=185!
> Inconsistency in columns:
> 1. Missing column Engine in upgrade Path.
> Looks like missed from HIVE-22046
> 2. Redundant columns which got removed as part of HIVE-27725 is not
> handled in the upgrade path
> {{ TAB_COL_STATS}} - {{DB_NAME}} and {{TABLE_NAME}}
> {{ PART_COL_STATS}} - {{{}DB_NAME{}}}, {{TABLE_NAME}} and {{PARTITION_NAME}}
> *2. Table SYSDB.SCHEDULED_QUERIES* **
> - Missing column ACTIVE_EXECUTION_ID - Looks like missed from HIVE-22872
> After Upgrade:
> !image-2024-08-14-18-59-57-815.png|width=541,height=260!
> Fresh install:
> !image-2024-08-14-19-00-30-680.png|width=539,height=259!
>
> *3. SYSDB.KEY_CONSTRAINTS*
> * Missing column constraint PARENT_TBL_ID - Looks like missed in HIVE-22728
> Fresh Path:
> !image-2024-08-14-19-04-16-332.png|width=628,height=437!
> Upgrade Path:
> !image-2024-08-14-19-04-55-550.png|width=672,height=383!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
