You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Brian Johnson <br...@brianjohnson.cc> on 2015/03/14 17:11:24 UTC
hbase snapshots
Can phoenix tables be restored from an hbase snapshot? I assume you also need to snapshot the system catalog, but won't restoring that affect all tables? Is there a way to snapshot/restore individual phoenix tables? Is there anything else that needs to be captured for a snapshot? Thanks.
Re: hbase snapshots
Posted by James Taylor <ja...@apache.org>.
No, not currently, but PHOENIX-1550 would provide that.
On Sat, Mar 14, 2015 at 2:36 PM, Brian Johnson <br...@brianjohnson.cc> wrote:
> But is there a way to avoid the create table step? It makes the restore process much more complicated
>
> On Mar 14, 2015, at 2:34 PM, James Taylor <ja...@apache.org> wrote:
>
>> You should be able to restore from a snapshot in the hbase shell and
>> then do a CREATE TABLE from sqlline to the restored snapshot and
>> Phoenix will map to it. If the table is large, the CREATE step may
>> take a while because Phoenix needs to ensure that every row has an
>> empty key value marker. Looks like there's some work beginning on
>> PHOENIX-1550 that would prevent that slowness.
>>
>> Thanks,
>> James
>>
>> On Sat, Mar 14, 2015 at 9:11 AM, Brian Johnson <br...@brianjohnson.cc> wrote:
>>> Can phoenix tables be restored from an hbase snapshot? I assume you also need to snapshot the system catalog, but won't restoring that affect all tables? Is there a way to snapshot/restore individual phoenix tables? Is there anything else that needs to be captured for a snapshot? Thanks.
>
Re: hbase snapshots
Posted by Brian Johnson <br...@brianjohnson.cc>.
But is there a way to avoid the create table step? It makes the restore process much more complicated
On Mar 14, 2015, at 2:34 PM, James Taylor <ja...@apache.org> wrote:
> You should be able to restore from a snapshot in the hbase shell and
> then do a CREATE TABLE from sqlline to the restored snapshot and
> Phoenix will map to it. If the table is large, the CREATE step may
> take a while because Phoenix needs to ensure that every row has an
> empty key value marker. Looks like there's some work beginning on
> PHOENIX-1550 that would prevent that slowness.
>
> Thanks,
> James
>
> On Sat, Mar 14, 2015 at 9:11 AM, Brian Johnson <br...@brianjohnson.cc> wrote:
>> Can phoenix tables be restored from an hbase snapshot? I assume you also need to snapshot the system catalog, but won't restoring that affect all tables? Is there a way to snapshot/restore individual phoenix tables? Is there anything else that needs to be captured for a snapshot? Thanks.
Re: hbase snapshots
Posted by James Taylor <ja...@apache.org>.
You should be able to restore from a snapshot in the hbase shell and
then do a CREATE TABLE from sqlline to the restored snapshot and
Phoenix will map to it. If the table is large, the CREATE step may
take a while because Phoenix needs to ensure that every row has an
empty key value marker. Looks like there's some work beginning on
PHOENIX-1550 that would prevent that slowness.
Thanks,
James
On Sat, Mar 14, 2015 at 9:11 AM, Brian Johnson <br...@brianjohnson.cc> wrote:
> Can phoenix tables be restored from an hbase snapshot? I assume you also need to snapshot the system catalog, but won't restoring that affect all tables? Is there a way to snapshot/restore individual phoenix tables? Is there anything else that needs to be captured for a snapshot? Thanks.