Support Questions
Find answers, ask questions, and share your expertise

Speed up phoenix' secondary indexes creation

Speed up phoenix' secondary indexes creation

Rising Star

Hello,

we have a phoenix table with about 44M records. We're creating a secondary index on it, but, after about 3 days, the index table on hbase is populated with ~ 340k records. At this rate, we expect the index to be active not before one month or more.

Is there a way to speed up the index creation?

We're using HDP 2.6.4 with Hbase 1.1.2 and Phoenix 4.7

Thank you