[ 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