[HIVE-3964] HIVE-3649.oracle.sql must update SDS table for IS_STOREDASSUBDIRECTORIES

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Assignee: Mithun Radhakrishnan
• Reporter: Mithun Radhakrishnan
• Created: 31/Jan/13 01:43
• Updated: 14/Mar/13 01:21

Description

The metastore-update script is available now on trunk/. (As part of HIVE-3931.)

However, on branch-10, the 011-HIVE-3649.oracle.sql script (that updates the SDS table) introduces a non-NULL constraint on a new field (that doesn't exist in the old schema). The correct way to update the SDS table is as it's done in trunk/:

ALTER TABLE SDS ADD IS_STOREDASSUBDIRECTORIES NUMBER(1) NULL;
UPDATE SDS SET IS_STOREDASSUBDIRECTORIES = 0;
ALTER TABLE SDS MODIFY(IS_STOREDASSUBDIRECTORIES NOT NULL);

We need to merge this change into branch-0.10/.