You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Samarth Jain <sa...@apache.org> on 2015/07/15 23:50:30 UTC
Re: PHOENIX-2000
Changing the email group to user@phoenix.apache.org. Please don't use
phoenix-hbase-user@googlegroups.com 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 <ak...@gmail.com> 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 phoenix-hbase-user+unsubscribe@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
Re: PHOENIX-2000
Posted by Samarth Jain <sa...@gmail.com>.
Nick, would you know why NPE is being thrown in this case?
On Fri, Jul 17, 2015 at 2:08 PM, Akshat Nair <ak...@gmail.com> 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 <sa...@apache.org> wrote:
>
>> Changing the email group to user@phoenix.apache.org. Please don't use
>> phoenix-hbase-user@googlegroups.com 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 <ak...@gmail.com> 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 phoenix-hbase-user+unsubscribe@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>