Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Select query getting below error for phoenix

avatar
Expert Contributor

select colun from view_name where rowid like '%ahsfkjshkfjhah==%';

java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException: Task org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@15f193b8 rejected from org.apache.phoenix.job.JobManager$1@2102a4d5[Running, pool size = 128, active threads = 128,

queued tasks = 1000, completed tasks = 15862]

1 ACCEPTED SOLUTION

avatar

You can increase

phoenix.query.threadPoolSize

to 256 or 512 based on number of machines/cores.

and also increase

phoenix.query.queueSize

to 5000 and add hbase-site.xml to class path or export HBASE_CONF_DIR.

You can refer http://phoenix.apache.org/tuning.html for more turning.

View solution in original post

2 REPLIES 2

avatar

You can increase

phoenix.query.threadPoolSize

to 256 or 512 based on number of machines/cores.

and also increase

phoenix.query.queueSize

to 5000 and add hbase-site.xml to class path or export HBASE_CONF_DIR.

You can refer http://phoenix.apache.org/tuning.html for more turning.

avatar
Expert Contributor

thank you for your immediate reply, is there any other approach are there at Hbase site pleaes recomend.