You absolutely can use snapshots with phoenix. You would need to snapshot both the phoenix metadata table and the table you want to snapshot.
Then on restore, you restore both those tables to new tables, point phoenix there and get the data you need. Missing pieces: 1) I'm not sure there is a way to just copy over the rows you would need from the metadata to bulk move the restored table back. This would be a great contribution. 2) Schema changes need to be locked while doing the snapshot so you dont see the wrong schema by accident. This may or may not exist - check the docs. What you really want is a per-table schema lock, but a wholesale schema lock would be sufficient, though slightly less clean. On Fri, Nov 14, 2014, 8:59 AM Alex Kamil <alex.ka...@gmail.com> wrote: > Is it possible to use hbase snapshots > <http://hbase.apache.org/book/ops.snapshots.html> with phoenix? > and what is the recommended process for backup and recovery > > thanks > Alex >
