Re: How to deal with Phoenix Secondary Indexes & HBase snapshots in batch job

2016-06-29 Thread vikashtalanki
/How-to-deal-with-Phoenix-Secondary-Indexes-HBase-snapshots-in-batch-job-tp1997p2001.html Sent from the Apache Phoenix User List mailing list archive at Nabble.com.

Re: Phoenix and HBase Snapshots

2016-02-14 Thread Gaurav Agarwal
Go to hbase shell Steps to take snapshot 1. Disable table 2 snapshot table 3 enable table 4 restore ssnapshot with different table name that is not created for present in hbase. Or Copy that snapshot to another cluster and restore snapshot. On Feb 13, 2016 11:24 PM, "Sandeep Nemuri"

Re: Phoenix and HBase Snapshots

2016-02-13 Thread Sandeep Nemuri
We have tried taking/restoring snapshots of Phoenix tables. How does it work ? As Gaurav mentioned , We should take snapshot or restore snapshot from hbase of the phoenix tables. Thanks Sandeep ᐧ On Sat, Feb 13, 2016 at 8:20 AM, James Taylor wrote: > Specifically

Phoenix and HBase Snapshots

2016-02-12 Thread Nick Dimiduk
Heya, Has anyone tried taking/restoring snapshots of Phoenix tables? How does that work out? Presumably we would require a sibling snapshot of some system tables as well. Have you tried the Export/Import/Restore workflow? Have you tried MR or Spark over the snapshots? Curious, -n

Re: Phoenix and HBase Snapshots

2016-02-12 Thread Gaurav Agarwal
We can take snapshot or restore snapshot from hbase of the phoenix tables. Export/import feature also hbase provide to us. Thanks On Feb 13, 2016 3:15 AM, "Nick Dimiduk" wrote: > Heya, > > Has anyone tried taking/restoring snapshots of Phoenix tables? How does > that work

Re: Phoenix and HBase Snapshots

2016-02-12 Thread James Taylor
Specifically schema changes from an HBase POV, like removing a column family or renaming the table. On Friday, February 12, 2016, Jesse Yates wrote: > Just have to make sure you don't have schema change during snapshots > > On Fri, Feb 12, 2016 at 6:24 PM Gaurav

Re: Phoenix and HBase Snapshots

2016-02-12 Thread Jesse Yates
Just have to make sure you don't have schema change during snapshots On Fri, Feb 12, 2016 at 6:24 PM Gaurav Agarwal wrote: > We can take snapshot or restore snapshot from hbase of the phoenix tables. > Export/import feature also hbase provide to us. > > Thanks > On Feb

Re: hbase snapshots

2015-03-14 Thread Brian Johnson
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 jamestay...@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

Re: hbase snapshots

2015-03-14 Thread James Taylor
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

hbase snapshots

2015-03-14 Thread Brian Johnson
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.