[
https://issues.apache.org/jira/browse/HIVE-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13152286#comment-13152286
]
Ashutosh Chauhan commented on HIVE-1187:
----------------------------------------
@Carl,
Has this been implemented? I cannot find any docs for this feature. Its
resolved as duplicate but the second issue referred is not resolved either.
> Implement ddldump utility for Hive Metastore
> --------------------------------------------
>
> Key: HIVE-1187
> URL: https://issues.apache.org/jira/browse/HIVE-1187
> Project: Hive
> Issue Type: New Feature
> Components: Metastore
> Affects Versions: 0.6.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
> Labels: ddl, derby, metastore, migration, mysql
>
> 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira