[ https://issues.apache.org/jira/browse/DRILL-4195?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16949390#comment-16949390 ]
Arina Ielchiieva commented on DRILL-4195: ----------------------------------------- Closing since this is rather old issue, please reopen if issue persists on newer Drill versions. > 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 > Priority: Major > Attachments: cre8table_trdmix91.sql, setup, test.class, test.java, > test.log, trdmix91.csv > > > 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 (v8.3.4#803005)