Nick, would you know why NPE is being thrown in this case? On Fri, Jul 17, 2015 at 2:08 PM, Akshat Nair <[email protected]> wrote:
> Hi > > Thanks that resolved the issue. I am running into another issue now. > > If I run this query on regular sqlline.py client then it works fine > "select null from my_schema.my_table" > But with sqlline-thin.py this gives an error. This is the exception > in /tmp/phoenix/phoenix-root-server.log > > > java.lang.NullPointerException > at java.util.Objects.requireNonNull(Objects.java:203) > at > org.apache.calcite.avatica.ColumnMetaData$AvaticaType.<init>(ColumnMetaData.java:237) > at > org.apache.calcite.avatica.ColumnMetaData$ScalarType.<init>(ColumnMetaData.java:256) > at > org.apache.calcite.avatica.ColumnMetaData.scalar(ColumnMetaData.java:119) > at > org.apache.calcite.avatica.jdbc.JdbcMeta.columns(JdbcMeta.java:206) > at > org.apache.calcite.avatica.jdbc.JdbcMeta.signature(JdbcMeta.java:246) > at > org.apache.calcite.avatica.jdbc.JdbcMeta.signature(JdbcMeta.java:252) > at > org.apache.calcite.avatica.jdbc.JdbcResultSet.create(JdbcResultSet.java:46) > at > org.apache.calcite.avatica.jdbc.JdbcMeta.prepareAndExecute(JdbcMeta.java:777) > at > org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:135) > at > org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:236) > at > org.apache.calcite.avatica.remote.Service$PrepareAndExecuteRequest.accept(Service.java:220) > at > org.apache.calcite.avatica.remote.JsonHandler.apply(JsonHandler.java:43) > at > org.apache.calcite.avatica.server.AvaticaHandler.handle(AvaticaHandler.java:55) > 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) > > And the error at the client side > > 0: jdbc:phoenix:thin:url=http://master:8765> select null from > my_schema.my_table; > Error: error while executing SQL "select null from my_schema.my_table": > response code 500 (state=,code=0) > java.sql.SQLException: error while executing SQL "select null from > my_schema.my_table": response code 500 > at org.apache.calcite.avatica.Helper.createException(Helper.java:39) > at > org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:111) > at > org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:120) > 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) > Caused by: java.lang.RuntimeException: response code 500 > at > org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:45) > at > org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:195) > at > org.apache.calcite.avatica.remote.RemoteMeta.prepareAndExecute(RemoteMeta.java:157) > at > org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:474) > at > org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:108) > ... 7 more > > > The version is > phoenix-4.4.0-HBase-0.98 and hbase-0.98.13-hadoop2 > > Any idea how to get around this issue? Or if this needs fixing? > > -Akshat > > > > > > > On Wed, Jul 15, 2015 at 2:50 PM, Samarth Jain <[email protected]> wrote: > >> Changing the email group to [email protected]. Please don't use >> [email protected] as that group is deprecated. >> >> >> Can you try upgrading your HBase version? I see that the way HBase >> configuration is being loaded has been changed in the later releases. I am >> not seeing the issue when running against 0.98.12-hadoop2. Can you try >> that one and let us know if this resolved it for you. >> >> Thanks, >> Samarth >> >> On Wed, Jul 15, 2015 at 1:56 PM, Akshat Nair <[email protected]> wrote: >> >>> Hi >>> >>> I am running into the same issue described in >>> https://issues.apache.org/jira/browse/PHOENIX-2000 >>> >>> The version I am using is phoenix-4.4.0-HBase-0.98 with HDP 2.1. >>> Hbase version is 0.98.0.2.1.1.0-385-hadoop2 >>> >>> Is there any workaround for this issue? I was unable to use both >>> sqlline.py and sqlline-thin.py. >>> >>> Thanks >>> Akshat >>> >>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Phoenix HBase User" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >
