Hive
  1. Hive
  2. HIVE-1918

Add export/import facilities to the hive system

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.8.0
    • Component/s: Metastore, Query Processor
    • Labels:
      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.

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

        Issue Links

          Activity

          Sho Shimauchi made changes -
          Link This issue relates to HIVE-4299 [ HIVE-4299 ]
          Carl Steinbach made changes -
          Link This issue relates to HIVE-2816 [ HIVE-2816 ]
          Carl Steinbach made changes -
          Assignee Carl Steinbach [ cwsteinbach ] Krishna Kumar [ n_krishna_kumar ]
          Carl Steinbach made changes -
          Assignee Krishna Kumar [ n_krishna_kumar ] Carl Steinbach [ cwsteinbach ]
          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Carl Steinbach made changes -
          Component/s Metastore [ 12312584 ]
          Paul Yang made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Fix Version/s 0.8.0 [ 12316178 ]
          Resolution Fixed [ 1 ]
          Krishna Kumar made changes -
          Attachment HIVE-1918.patch.5.txt [ 12472202 ]
          Krishna Kumar made changes -
          Attachment HIVE-1918.patch.5.txt [ 12473539 ]
          Krishna Kumar made changes -
          Attachment HIVE-1918.patch.5.txt [ 12472202 ]
          Krishna Kumar made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Krishna Kumar made changes -
          Attachment HIVE-1918.patch.4.txt [ 12470864 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Namit Jain made changes -
          Assignee Krishna Kumar [ n_krishna_kumar ]
          Krishna Kumar made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Krishna Kumar made changes -
          Attachment HIVE-1918.patch.3.txt [ 12470063 ]
          Krishna Kumar made changes -
          Attachment HIVE-1918.patch.2.txt [ 12469801 ]
          Krishna Kumar made changes -
          Attachment hive-metastore-er.pdf [ 12469129 ]
          Krishna Kumar made changes -
          Attachment HIVE-1918.patch.1.txt [ 12469128 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Krishna Kumar made changes -
          Attachment HIVE-1918.patch.txt [ 12468726 ]
          Krishna Kumar made changes -
          Field Original Value New Value
          Status Open [ 1 ] Patch Available [ 10002 ]
          Krishna Kumar created issue -

            People

            • Assignee:
              Krishna Kumar
              Reporter:
              Krishna Kumar
            • Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development