You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Hari Sekhon (JIRA)" <ji...@apache.org> on 2015/02/10 14:37:12 UTC

[jira] [Updated] (HIVE-9637) Hive Snapshots - Metadata recovery (tightly coupled with HDFS data recovery)

     [ https://issues.apache.org/jira/browse/HIVE-9637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hari Sekhon updated HIVE-9637:
------------------------------
    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 also.

Regards,

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

  was:
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 tied together 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 and able to restore both HDFS data and Hive Metadata in a single Hive command also.

Regards,

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


> Hive Snapshots - Metadata recovery (tightly coupled with HDFS data recovery)
> ----------------------------------------------------------------------------
>
>                 Key: HIVE-9637
>                 URL: https://issues.apache.org/jira/browse/HIVE-9637
>             Project: Hive
>          Issue Type: New Feature
>          Components: Database/Schema, SQL
>    Affects Versions: 0.14.0
>         Environment: HDP 2.2
>            Reporter: Hari Sekhon
>
> 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 also.
> Regards,
> Hari Sekhon
> http://www.linkedin.com/in/harisekhon



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)