[ 
https://issues.apache.org/jira/browse/HIVE-1902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Arvind Prabhakar updated HIVE-1902:
-----------------------------------

    Release Note: If migrating from a Hive 0.6 installation, please use the 
appropriate upgrade script to upgrade the metastore prior to first use of the 
system.
          Status: Patch Available  (was: Open)

This change introduces the necessary upgrade scripts for upgrading metastore 
schema for Hive 0.6 to Hive 0.7. The scripts included are for Derby and MySQL 
5.1.48 databases. 

This change also fixes HIVE-1904 and HIVE-1905.

Tested the scripts as follows:

) Checked out the 0.6.0 branch and created derby and mysql based metastore 
databases.

2) Checked out and built the 0.7.0 branch.

3) Applied the following configuration settings in hive-site.xml:
datanucleus.validateTables=true
datanucleus.validateColumns=true
datanucleus.validateConstraints=true
datanucleus.autoCreateSchema=false

4) Verified that using either the mysql or derby metastores resulted in schema 
validation errors.

5) Applied the 0.7.0 metastore upgrade scripts to the respective metastore DBs.

6) Verified that both metastore DBs work after applying the upgrade script.

> create script for the metastore upgrade due to HIVE-78
> ------------------------------------------------------
>
>                 Key: HIVE-1902
>                 URL: https://issues.apache.org/jira/browse/HIVE-1902
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>            Reporter: Namit Jain
>            Assignee: Arvind Prabhakar
>            Priority: Blocker
>             Fix For: 0.7.0
>
>         Attachments: HIVE-1902.1.patch.txt
>
>


-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to