[HIVE-19230] Schema column width inconsistency in Oracle

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 3.1.0, 3.0.0
• Component/s: Hive
• Assignee: Naveen Gangam
• Reporter: Naveen Gangam
• Created: 17/Apr/18 21:00
• Updated: 22/May/18 23:14
• Resolved: 23/Apr/18 17:57

Description

This is for oracle only. Does not appear to be an issue with other DBs. When you upgrade hive schema from 2.1.0 to hive 3.0.0, the width of TXN_COMPONENTS.TC_TABLE is 256 and COMPLETED_TXN_COMPONENTS.CTC_TABLE is 128.

But if you install hive 3.0 schema directly, their widths are 128 and 256 respectively. This is consistent with schemas for other databases.

Issue Links

• is caused by: HIVE-12274 Increase width of columns used for general configuration in the metastore.