[jira] [Commented] (PHOENIX-1550) Freeze and thaw Phoenix tables

["Sun Fulin (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-1550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14315876#comment-14315876 ] 

Sun Fulin commented on PHOENIX-1550:
------------------------------------

Any progress on this issue ? [~apurtell]

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