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.
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
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
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
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
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
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
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
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
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
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
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.
12 matches
Mail list logo