[
https://issues.apache.org/jira/browse/HIVE-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12837583#action_12837583
]
Edward Capriolo commented on HIVE-1187:
---------------------------------------
+1 Having 'show create table' XXXX' will be very useful. I always seem to
lose those table definitions.
> Implement ddldump utility for Hive Metastore
> --------------------------------------------
>
> Key: HIVE-1187
> URL: https://issues.apache.org/jira/browse/HIVE-1187
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Metastore
> Affects Versions: 0.6.0
> Reporter: Carl Steinbach
> Assignee: Carl Steinbach
>
> 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.
-
You can reply to this email to add a comment to the issue online.
