[HIVE-1427] Provide metastore schema migration scripts (0.5 -> 0.6)

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.6.0
• Component/s: Metastore
• Hadoop Flags: Reviewed
• Assignee: Carl Steinbach
• Reporter: Carl Steinbach
• Created: 22/Jun/10 22:39
• Updated: 17/Dec/11 00:03
• Resolved: 06/Oct/10 21:03

Description

At a minimum this ticket covers packaging up example MySQL migration scripts (cumulative across all schema changes from 0.5 to 0.6) and explaining what to do with them in the release notes.

This is also probably a good point at which to decide and clearly state which Metastore DBs we officially support in production, e.g. do we need to provide migration scripts for Derby?

Issue Links

• incorporates: HIVE-1697 Migration scripts should increase size of PARAM_VALUE in PARTITION_PARAMS
• incorporates: HIVE-1709 Provide Postgres metastore schema migration scripts (0.5 -> 0.6)
• is blocked by: HIVE-1364 Increase the maximum length of various metastore fields, and remove TYPE_NAME from COLUMNS primary key
• is related to: HIVE-1364 Increase the maximum length of various metastore fields, and remove TYPE_NAME from COLUMNS primary key
• is related to: HIVE-972 Support views