[
https://issues.apache.org/jira/browse/HIVE-3964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mithun Radhakrishnan updated HIVE-3964:
---------------------------------------
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/.
was:
The metastore-update script is available now on trunk/. (As part of HIVE-3931.)
However, 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/.
> HIVE-3649.oracle.sql must update SDS table for IS_STOREDASSUBDIRECTORIES
> ------------------------------------------------------------------------
>
> Key: HIVE-3964
> URL: https://issues.apache.org/jira/browse/HIVE-3964
> Project: Hive
> Issue Type: Bug
> Reporter: Mithun Radhakrishnan
> Assignee: Mithun Radhakrishnan
> Attachments: HIVE-3964.branch10.patch
>
>
> 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/.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
