You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by KhajaAsmath Mohammed <md...@gmail.com> on 2022/09/20 17:18:04 UTC
Re: Unable to do count(*) on hbase view
On Tue, Sep 20, 2022 at 12:14 PM KhajaAsmath Mohammed <
mdkhajaasmath@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)
>
Re: Unable to do count(*) on hbase view
Posted by Istvan Toth <st...@cloudera.com>.
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 <
mdkhajaasmath@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*: stoty@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>
------------------------------
------------------------------
Fwd: Unable to do count(*) on hbase view
Posted by KhajaAsmath Mohammed <md...@gmail.com>.
>
>
> 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)
>