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) <warwit...@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) >
