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