Performance of Inserting HBASE Phoenix table via Hive

What are the performance implications of Inserting HBASE Phoenix table via Hive? Any good practices around it? How is the performance compared to jdbc insert or phoenix csv upload? Any pointers would be of great help.

Re: transfer all data to another cluster

I think u can use Habase export/import http://hbase.apache.org/0.94/book/ops_mgt.html#export On Tue, 14 Nov 2017 at 9:59 AM, Cheyenne Forbes < cheyenne.osanu.for...@gmail.com> wrote: > Is there a standard way to move all apache phoenix data to a new cluster? > and how long would it take to move 2

Re: Growth in table size and performance degradation on read-queries

Is the replication enabled and setup properly? Are you creating snapshots or is backup enabled (hbase.backup.enable) ? Check under ../hbase folder whats actually taking more space. On Wed, 30 Jan 2019 at 6:24 AM, talluri abhishek wrote: > Hi Vincent, > > Versions is set to1 and keep_deleted_ce

Re: Growth in table size and performance degradation on read-queries

Also check whats the value for hbase.master.hfilecleaner.ttl? On Wed, 30 Jan 2019 at 7:31 AM, sudhir patil wrote: > Is the replication enabled and setup properly? > Are you creating snapshots or is backup enabled (hbase.backup.enable) ? > > > Check under ../hbase folder whats

Re: Materialized views in Hbase/Phoenix

Few options 1. Have you checked olap db’s on top of hbase like Kylene? It would fit agg requirement 2. Writing hbase coprocessor to agg and save and save another table or column family? Implementing coprocessor is not trivial though On Sat, 12 Oct 2019 at 12:49 AM, Nicolas Paris wrote: > > If