You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by "김영우 (Youngwoo Kim)" <wa...@gmail.com> on 2015/12/19 06:47:54 UTC

Remote driver error: Encountered exception in sub plan [0] execution

Hi,

I'm running Phoenix(current master branch) and HBase(1.1.2)

My query failed with an error as following [1]. two tables, each table has
1 billion rows. Salted with 20 buckets and compressed with SNAPPY. it's
just simple inner join like this:

SELECT a.val1 FROM tbl1 a INNER JOIN tbl2 b ON a.id=b.id

Joins with small tables work fine, so, I can not reproduce this from other
tables.

Any help would be appreciated!

Thanks,
- Youngwoo


[1]. Error from sqlline-thin:

Remote driver error: Encountered exception in sub plan [0] execution.
at org.apache.calcite.avatica.Helper.createException(Helper.java:49)
at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:143)
at
org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:177)
at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:808)
at sqlline.SqlLine.begin(SqlLine.java:681)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
java.lang.RuntimeException: Encountered exception in sub plan [0] execution.
at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:651)
at
org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:715)
at
org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:179)
at
org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:1049)
at
org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:1023)
at
org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:100)
at
org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:38)
at
org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:63)
at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
at
org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
at
org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)

Re: Remote driver error: Encountered exception in sub plan [0] execution

Posted by "김영우 (Youngwoo Kim)" <wa...@gmail.com>.

Never mind, my bad! I forgot to configure appropriate value
of phoenix.query.maxServerCacheBytes

- Youngwoo

On Sat, Dec 19, 2015 at 2:47 PM, 김영우 (Youngwoo Kim) <wa...@gmail.com>
wrote:

> Hi,
>
> I'm running Phoenix(current master branch) and HBase(1.1.2)
>
> My query failed with an error as following [1]. two tables, each table has
> 1 billion rows. Salted with 20 buckets and compressed with SNAPPY. it's
> just simple inner join like this:
>
> SELECT a.val1 FROM tbl1 a INNER JOIN tbl2 b ON a.id=b.id
>
> Joins with small tables work fine, so, I can not reproduce this from other
> tables.
>
> Any help would be appreciated!
>
> Thanks,
> - Youngwoo
>
>
> [1]. Error from sqlline-thin:
>
> Remote driver error: Encountered exception in sub plan [0] execution.
> at org.apache.calcite.avatica.Helper.createException(Helper.java:49)
> at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
> at
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:143)
> at
> org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:177)
> at sqlline.Commands.execute(Commands.java:822)
> at sqlline.Commands.sql(Commands.java:732)
> at sqlline.SqlLine.dispatch(SqlLine.java:808)
> at sqlline.SqlLine.begin(SqlLine.java:681)
> at sqlline.SqlLine.start(SqlLine.java:398)
> at sqlline.SqlLine.main(SqlLine.java:292)
> java.lang.RuntimeException: Encountered exception in sub plan [0]
> execution.
> at org.apache.calcite.avatica.jdbc.JdbcMeta.propagate(JdbcMeta.java:651)
> at
> org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:715)
> at
> org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:179)
> at
> org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:1049)
> at
> org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:1023)
> at
> org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:100)
> at
> org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:38)
> at
> org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:63)
> at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
> at
> org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
> at org.eclipse.jetty.server.Server.handle(Server.java:497)
> at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
> at
> org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:245)
> at
> org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
> at
> org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
> at java.lang.Thread.run(Thread.java:745)
>