[HIVE-1918] Add export/import facilities to the hive system

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Metastore, Query Processor
• Assignee: Krishna Kumar
• Reporter: Krishna Kumar
• Created: 17/Jan/11 15:49
• Updated: 04/Jul/13 08:35
• Resolved: 15/Mar/11 20:30

Description

This is an enhancement request to add export/import features to hive.

With this language extension, the user can export the data of the table - which may be located in different hdfs locations in case of a partitioned table - as well as the metadata of the table into a specified output location. This output location can then be moved over to another different hadoop/hive instance and imported there.

This should work independent of the source and target metastore dbms used; for instance, between derby and mysql.

For partitioned tables, the ability to export/import a subset of the partition must be supported.

Howl will add more features on top of this: The ability to create/use the exported data even in the absence of hive, using MR or Pig. Please see http://wiki.apache.org/pig/Howl/HowlImportExport for these details.

Issue Links

• relates to: HIVE-4299 exported metadata by HIVE-3068 cannot be imported because of wrong file name
• relates to: HIVE-2816 Extend IMPORT/EXPORT with metadata only option