[HIVE-1187] Implement ddldump utility for Hive Metastore

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.6.0
• Component/s: Metastore
• Labels: ddl derby metastore migration mysql
• Assignee: Carl Steinbach
• Reporter: Carl Steinbach
• Created: 22/Feb/10 16:51
• Updated: 18/Nov/11 18:31
• Resolved: 10/Jun/10 16:49

Description

Implement a ddldump utility for the Hive metastore that will generate the QL DDL necessary to recreate the state of the current metastore on another metastore instance.

A major use case for this utility is migrating a metastore from one database to another database, e.g. from an embedded Derby instanced to a MySQL instance.

The ddldump utility should support the following features:

• Ability to generate DDL for specific tables or all tables.
• Ability to specify a table name prefix for the generated DDL, which will be useful for resolving table name conflicts.

Issue Links

• duplicates: HIVE-967 Implement "show create table"