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

Select query getting below error for phoenix

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

Accepted Solutions

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

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

Expert Contributor

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