phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergey Soldatov <sergeysolda...@gmail.com>
Subject Re: Performance of Inserting HBASE Phoenix table via Hive
Date Tue, 10 Oct 2017 03:07:36 GMT
You need to remember, that inserting into Phoenix from Hive is going
through an additional layer (StorageHandler) which is not optimized like
ORC or other Hive specific formats. So you may expect that it will be
visible slower than regular Hive table and very slow comparing to the
regular Phoenix upserts (dozen times or even more). If you need to
duplicate a lot of information from Hive to Phoenix, CSV bulkload is the
best way to perform such operations.

Thanks,
Sergey

On Tue, Oct 10, 2017 at 4:31 AM, sudhir patil <spatil.sudhir@gmail.com>
wrote:

>
>
> 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.
>
>
>

Mime
View raw message