[jira] [Created] (DRILL-4195) NullPointerException received on ResultSet.next() call for query

["Sergio Lob (JIRA)" <ji...@apache.org>]

Sergio Lob created DRILL-4195:
---------------------------------

             Summary: NullPointerException received on ResultSet.next() call for query
                 Key: DRILL-4195
                 URL: https://issues.apache.org/jira/browse/DRILL-4195
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - JDBC
    Affects Versions: 1.2.0
         Environment: Linux lnxx64r6 2.6.32-131.0.15.el6.x86_64 #1 SMP Tue May 10 15:42:40 EDT 2011 x86_64 x86_64 x86_64 GNU/Linux
            Reporter: Sergio Lob


NullPointerException received on ResultSet.next() call for a particular query. We have several different queries that produce NullPointerException. One is:

"SELECT T1.`fa02int` AS `SK001`, MAX(T1.`fa06char_5`) FROM `hive`.`default`.`trdmix91` `T1` GROUP BY T1.`fa02int` ORDER BY `SK001`"

During invocation of rs.ext(), I receive the following
exception stack trace:

invoking ResultSet.next() to get to first row:
********Exception: java.sql.SQLException: SYSTEM ERROR: NullPointerException

Fragment 0:0

[Error Id: e7dc2d6e-ab32-4d6d-a593-7fe09a677393 on maprdemo:31010]
java.sql.SQLException: SYSTEM ERROR: NullPointerException

Fragment 0:0

[Error Id: e7dc2d6e-ab32-4d6d-a593-7fe09a677393 on maprdemo:31010]
        at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.
java:247)
        at org.apache.drill.jdbc.impl.DrillCursor.next(DrillCursor.java:320)
        at oadd.net.hydromatic.avatica.AvaticaResultSet.next(AvaticaResultSet.ja
va:187)
        at org.apache.drill.jdbc.impl.DrillResultSetImpl.next(DrillResultSetImpl
.java:160)
        at test.main(test.java:64)
Caused by: oadd.org.apache.drill.common.exceptions.UserRemoteException: SYSTEM E
RROR: NullPointerException

Fragment 0:0

[Error Id: e7dc2d6e-ab32-4d6d-a593-7fe09a677393 on maprdemo:31010]
        at oadd.org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(
QueryResultHandler.java:118)
        at oadd.org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClie
nt.java:110)
        at oadd.org.apache.drill.exec.rpc.BasicClientWithConnection.handle(Basic
ClientWithConnection.java:47)
        at oadd.org.apache.drill.exec.rpc.BasicClientWithConnection.handle(Basic
ClientWithConnection.java:32)
        at oadd.org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:61)
        at oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.ja
va:233)
        at oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.ja
va:205)
        at oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(Messa
geToMessageDecoder.java:89)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead
(AbstractChannelHandlerContext.java:339)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(A
bstractChannelHandlerContext.java:324)
        at oadd.io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateH
andler.java:254)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead
(AbstractChannelHandlerContext.java:339)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(A
bstractChannelHandlerContext.java:324)
        at oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(Messa
geToMessageDecoder.java:103)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead
(AbstractChannelHandlerContext.java:339)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(A
bstractChannelHandlerContext.java:324)
        at oadd.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMe
ssageDecoder.java:242)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead
(AbstractChannelHandlerContext.java:339)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(A
bstractChannelHandlerContext.java:324)
        at oadd.io.netty.channel.ChannelInboundHandlerAdapter.channelRead(Channe
lInboundHandlerAdapter.java:86)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead
(AbstractChannelHandlerContext.java:339)
        at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(A
bstractChannelHandlerContext.java:324)
        at oadd.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultC
hannelPipeline.java:847)
        at oadd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(A
bstractNioByteChannel.java:131)
        at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoo
p.java:511)
        at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(N
ioEventLoop.java:468)
        at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLo
op.java:382)
        at oadd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
        at oadd.io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleT
hreadEventExecutor.java:111)
        at java.lang.Thread.run(Thread.java:722)


I am providing the procedure to create the test table and the java repro (test.java). 





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)