You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Carl Steinbach (JIRA)" <ji...@apache.org> on 2010/02/22 17:52:27 UTC
[jira] Created: (HIVE-1187) Implement ddldump utility for Hive
Metastore
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.
[jira] Commented: (HIVE-1187) Implement ddldump utility for Hive
Metastore
Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
[ 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.
[jira] Commented: (HIVE-1187) Implement ddldump utility for Hive
Metastore
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12837563#action_12837563 ]
Carl Steinbach commented on HIVE-1187:
--------------------------------------
@Ed: I don't think there is much overlap between this enhancement and what is described in HIVE-1161. I expect that HIVE-1161 will involve triggering the transfer of metadata over Thrift or JDBC from one metastore to another, or via an agent that accesses both metastores via the client APIs. Dumping DDL from one metastore and replaying it on another seems like a hacky way to synchronize/transmit metadata.
> 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.
[jira] Resolved: (HIVE-1187) Implement ddldump utility for Hive
Metastore
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach resolved HIVE-1187.
----------------------------------
Resolution: Duplicate
> 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.
[jira] Commented: (HIVE-1187) Implement ddldump utility for Hive
Metastore
Posted by "Edward Capriolo (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-1187?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12837048#action_12837048 ]
Edward Capriolo commented on HIVE-1187:
---------------------------------------
Do you want to team up on:
https://issues.apache.org/jira/browse/HIVE-1161 ?
> 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.