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

Hive Snapshots - Metadata recovery (tightly coupled with HDFS data recovery)

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.14.0
    • Fix Version/s: None
    • Component/s: Database/Schema, SQL
    • Labels:
      None
    • Environment:

      HDP 2.2

      Description

      Feature request to add Hive HQL Snapshots against tables / databases that save the Hive metadata, analagous to HDFS snapshots for storage.

      Currently HDFS snapshots do not address the loss of Hive Metadata if a Hive user were to drop a table - it would need to be re-entered manually from HQL scripts as well as HDFS snapshot data restored.

      Hive Snapshots should ideally be tightly coupled with HDFS snapshots so a single HQL command would trigger a simulatenous snapshot of the table HDFS data and Hive Metadata.

      These snapshots should be visible from Hive shell / beeline session and able to restore both HDFS data and Hive Metadata in a single Hive command.

      Regards,

      Hari Sekhon
      http://www.linkedin.com/in/harisekhon

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              harisekhon Hari Sekhon
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: