Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

HBase & Phoenix Query Server Tuning properties.

Hi,

I'm doing POC on HBase and Phoenix Query Server for next project. We would like to tune both the services for the best outcome for operations on 100million records. Right now we are using most of the default parameters which come with Hortonworks installation.

Can anyone provide the best set of tuning properties operations on 100million records?

Any help is highly appreciated and thanks in advance.

1 ACCEPTED SOLUTION

2 REPLIES 2

Some extra thoughts on top of Rajeshbabu's reply:

1. Increase the heapsize of the Phoenix Query Server via the PHOENIX_QUERYSERVER_OPTS variable hbase-env.sh

2. For writing data, make sure the addBatch() and executeBatch() API calls are used for the best performance