Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-1187

Implement ddldump utility for Hive Metastore

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

      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.

        Attachments

        Issue Links

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              cwsteinbach Carl Steinbach Assign to me
              Reporter:
              cwsteinbach Carl Steinbach

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment