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

Add export/import facilities to the hive system

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 0.8.0
    • Metastore, Query Processor
    • None

    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.

      Attachments

        1. hive-metastore-er.pdf
          137 kB
          Krishna Kumar
        2. HIVE-1918.patch.txt
          312 kB
          Krishna Kumar
        3. HIVE-1918.patch.5.txt
          394 kB
          Krishna Kumar
        4. HIVE-1918.patch.4.txt
          412 kB
          Krishna Kumar
        5. HIVE-1918.patch.3.txt
          361 kB
          Krishna Kumar
        6. HIVE-1918.patch.2.txt
          317 kB
          Krishna Kumar
        7. HIVE-1918.patch.1.txt
          311 kB
          Krishna Kumar

        Issue Links

          Activity

            People

              n_krishna_kumar Krishna Kumar
              n_krishna_kumar Krishna Kumar
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: