[HIVE-4024] Derby metastore update script will fail when upgrading from 0.9.0 to 0.10.0

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Hadoop Flags: Reviewed
• Assignee: Jarek Jarcec Cecho
• Reporter: Jarek Jarcec Cecho
• Created: 15/Feb/13 03:53
• Updated: 16/May/13 21:10
• Resolved: 19/Feb/13 03:58

Description

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

ALTER TABLE "SDS" ADD  "IS_STOREDASSUBDIRECTORIES" CHAR(1) NOT NULL;

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

Issue Links

• relates to: HIVE-3995 PostgreSQL upgrade scripts are not valid
• relates to: HIVE-3998 Oracle metastore update script will fail when upgrading from 0.9.0 to 0.10.0
• relates to: HIVE-3999 Mysql metastore upgrade script will end up with different schema than the full schema load
• links to: Review board