question Re: Select query getting below error for phoenix in Archives of Support Questions (Read Only)

Select query getting below error for phoenix

shivkumar82015 — Thu, 23 Mar 2017 16:29:24 GMT

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]

Re: Select query getting below error for phoenix

rchintaguntla — Thu, 23 Mar 2017 17:04:21 GMT

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.

Re: Select query getting below error for phoenix

shivkumar82015 — Fri, 24 Mar 2017 17:47:05 GMT

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