Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Select query getting below error for phoenix

Solved Go to solution

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

Re: Select query getting below error for phoenix

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.

2 REPLIES 2

Re: Select query getting below error for phoenix

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

Expert Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here