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 truncate

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

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 truncate

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

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.