You need to increase phoenix.query.queueSize and/or phoenix.stats.guidepost.width.
The number of guideposts in your table must not exceed phoenix.query.queueSize, otherwise full scans will fail. see https://phoenix.apache.org/tuning.html On Tue, Sep 20, 2022 at 8:02 PM KhajaAsmath Mohammed < mdkhajaasm...@gmail.com> wrote: > >> Hi, >> >> I am new to phoenix. I am doing simple count(*) on view and it throws me >> exception. Select * from table limit 5 works though. Any suggestions on >> this please? >> >> *select count(*) from "prewards_event";* >> >> Error: Error -1 (00000) : Error while executing SQL "select count(*) from >> "prewards_event"": Remote driver error: RuntimeException: >> org.apache.phoenix.exception.PhoenixIOException: Task >> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e >> rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool >> size = 128, active threads = 128, queued tasks = 5000, completed tasks = >> 102519] -> PhoenixIOException: Task >> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e >> rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool >> size = 128, active threads = 128, queued tasks = 5000, completed tasks = >> 102519] -> RejectedExecutionException: Task >> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e >> rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool >> size = 128, active threads = 128, queued tasks = 5000, completed tasks = >> 102519] (state=00000,code=-1) >> org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaSqlException: >> Error -1 (00000) : Error while executing SQL "select count(*) from >> "prewards_event"": Remote driver error: RuntimeException: >> org.apache.phoenix.exception.PhoenixIOException: Task >> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e >> rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool >> size = 128, active threads = 128, queued tasks = 5000, completed tasks = >> 102519] -> PhoenixIOException: Task >> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e >> rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool >> size = 128, active threads = 128, queued tasks = 5000, completed tasks = >> 102519] -> RejectedExecutionException: Task >> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e >> rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool >> size = 128, active threads = 128, queued tasks = 5000, completed tasks = >> 102519] >> at >> org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:54) >> at >> org.apache.phoenix.shaded.org.apache.calcite.avatica.Helper.createException(Helper.java:41) >> at >> org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:163) >> at >> org.apache.phoenix.shaded.org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:217) >> at sqlline.Commands.execute(Commands.java:822) >> at sqlline.Commands.sql(Commands.java:732) >> at sqlline.SqlLine.dispatch(SqlLine.java:813) >> at sqlline.SqlLine.begin(SqlLine.java:686) >> at sqlline.SqlLine.start(SqlLine.java:398) >> at sqlline.SqlLine.main(SqlLine.java:291) >> at >> org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:93) >> java.lang.RuntimeException: >> org.apache.phoenix.exception.PhoenixIOException: Task >> org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask@4fd9684e >> rejected from org.apache.phoenix.job.JobManager$1@32a702c8[Running, pool >> size = 128, active threads = 128, queued tasks = 5000, completed tasks = >> 102519] >> at >> org.apache.calcite.avatica.jdbc.JdbcResultSet.create(JdbcResultSet.java:109) >> at >> org.apache.calcite.avatica.jdbc.JdbcResultSet.create(JdbcResultSet.java:81) >> at >> org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:759) >> at >> org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:206) >> at >> org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:927) >> at >> org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:879) >> at >> org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:94) >> at >> org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:46) >> at >> org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:127) >> at >> org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52) >> > -- *István Tóth* | Sr. Staff Software Engineer *Email*: st...@cloudera.com cloudera.com <https://www.cloudera.com> [image: Cloudera] <https://www.cloudera.com/> [image: Cloudera on Twitter] <https://twitter.com/cloudera> [image: Cloudera on Facebook] <https://www.facebook.com/cloudera> [image: Cloudera on LinkedIn] <https://www.linkedin.com/company/cloudera> ------------------------------ ------------------------------
