>
>
> 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)
>
