[ https://issues.apache.org/jira/browse/HIVE-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13153026#comment-13153026 ]
Carl Steinbach commented on HIVE-1187: -------------------------------------- @Ashutosh: No, I don't think this feature has been implemented. This ticket was resolved as a duplicate of HIVE-967, but I don't think there has been any work on 967 since then. > 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