[
https://issues.apache.org/jira/browse/PHOENIX-1550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14361960#comment-14361960
]
maghamravikiran commented on PHOENIX-1550:
------------------------------------------
[~Andrew Purtell]
I would like to work on this JIRA. I was planning on the following in
priority and as things progress, based on feedback I will keep adding to the
list.
a) A SQL DML to create a snapshot on a table.
CREATE SNAPSHOT TBL_A ON TBL_A ASYNC CASCADE
ASYNC - for offline snapshots
CASCADE - for taking snapshots of the indexes also
b) Map Reduce support on reading from snapshots .
c) Support for RESTORE and CLONE from snapshots using queries.
Please share your views if this a good start to make .
> Freeze and thaw Phoenix tables
> ------------------------------
>
> Key: PHOENIX-1550
> URL: https://issues.apache.org/jira/browse/PHOENIX-1550
> Project: Phoenix
> Issue Type: New Feature
> Reporter: Andrew Purtell
>
> HBase snapshots provide a way to freeze the state of a table and then later
> restore that state from the snapshot or clone it into a new table. This can
> be very convenient for a wide range of use cases. However, we can't apply
> this technique directly to Phoenix tables because Phoenix generates and uses
> more state in more locations than a basic HBase table - a Phoenix table may
> have one or more secondary indexes, global or local, schema in the system
> catalog, sequence state, statistics.
> This issue is about considering a freeze and thaw feature for Phoenix tables,
> perhaps based on HBase snapshots. A freeze operation would create a
> consistent point in time snapshot of a Phoenix table and all related index
> data and metadata. A thaw operation would restore frozen state either by
> overwriting the table or by cloning the state into a new table.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
