[
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)
