[HIVE-3998] Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: Metastore
• Hadoop Flags: Reviewed
• Assignee: Jarek Jarcec Cecho
• Reporter: Jarek Jarcec Cecho
• Created: 07/Feb/13 21:02
• Updated: 16/May/13 21:10
• Resolved: 08/Feb/13 11:47

Description

The problem is in following file 011-HIVE-3649.oracle.sql that contains following line:

alter table  SDS add IS_STOREDASSUBDIRECTORIES NUMBER(1) NOT NULL;

This query will however fail if the table SDS have at least one row.

Issue Links

• is related to: HIVE-3995 PostgreSQL upgrade scripts are not valid
• is related to: HIVE-3999 Mysql metastore upgrade script will end up with different schema than the full schema load
• is related to: HIVE-4024 Derby metastore update script will fail when upgrading from 0.9.0 to 0.10.0