[HIVE-7118] Oracle upgrade schema scripts do not map Java long datatype columns correctly for transaction related tables

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 0.14.0
• Component/s: Database/Schema

Environment

Oracle DB

• Assignee: Deepesh Khandelwal
• Reporter: Deepesh Khandelwal
• Created: 23/May/14 02:35
• Updated: 13/Nov/14 19:42
• Resolved: 24/Jun/14 17:32

Description

In Transaction related tables, Java long column fields are mapped to NUMBER(10) which results in failure to persist the transaction ids which are incompatible. Following error is seen:

ORA-01438: value larger than specified precision allowed for this column

NO PRECOMMIT TESTS

Issue Links

• is duplicated by: HIVE-7259 Transaction manager fails when Oracle used as metastore RDBMS
• is related to: HIVE-8239 MSSQL upgrade schema scripts does not map Java long datatype columns correctly for transaction related tables