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

2016-06-29 Thread vikashtalanki
e.com/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.

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

2016-06-28 Thread Vamsi Krishna
Team, We are using HDP 2.3.2 (HBase 1.1.2, Phoenix 4.4.0). We have two Phoenix tables 'TABLE_A', 'TABLE_B' and a Phoenix view 'TABLE_VIEW'. Phoenix view is always pointing to one of the above two Phoenix tables which is called Active table and the other table is called Standby table. We have a ba

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" wrote: > We

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 schema changes from an HBase P

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 Agarwal > wrote: > >> We can ta

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 13, 2016 3:15 AM, "Nick Di

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 out? Presumably we woul

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: 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 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 wrote: > >> You should be able to

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

Re: hbase snapshots

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

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.