Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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.