phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jonathan Leech <jonat...@gmail.com>
Subject Re: copy table to remote cluster
Date Sat, 16 Jul 2016 03:10:34 GMT
If the table is small, you can export to a flat file, copy it over, then import, all using
Phoenix cmd line utilities.

If there is connectivity between the clusters, and the schema is identical, for small to mid-size
tables, you can set up hbase replication, and do upsert into x select * from x. You can also
replicate secondary indexes.

For larger tables use hbase snapshots, again you need connectivity. 

You can use a combination of the above to seed a cluster from another, and keep the data in
sync continuously, either one direction or both. 

Hope this helps,
Jonathan

> On Jul 15, 2016, at 11:27 AM, Pariksheet Barapatre <pbarapatre@gmail.com> wrote:
> 
> You can use PIG script as well. Just 4 lines of code and your are done, as Phoenix has
both PIG Loader and storage handler.
> 
> Cheers
> Pari
> 
>> On 15 July 2016 at 22:26, Li Gao <gaol@marinsoftware.com> wrote:
>> You can use spark that has access to both clusters. Distcp would also work. 
>> 
>>> On Fri, Jul 15, 2016 at 9:37 AM, Otmane K. <otmane.elkouaihi@gmail.com>
wrote:
>>> Hello,
>>> 
>>> What is the best way to copy Phoenix table from one cluster to another one ?

>>> 
>>> Thank you,
>>> Otmane
> 
> 
> 
> -- 
> Cheers,
> Pari

Mime
View raw message