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
Hi Brian,
What version of HBase and Phoenix are you using? I tried the following
on 4.3.0 with 0.98.9-hadoop2 and it worked fine for me:
- From sqlline:
create table FOO(k bigint primary key, v varchar);
upsert into foo values(1,'a');
1 row affected (0.047 seconds)
select * from foo;
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
If we truncate an hbase table that has a phoenix table defined for it, we can
no longer query for new data added to that table through hbase. I know that
truncate drops and recreates the table, but why does that affect phoenix and is
there some way to truncate that doesn't require also
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.