[ https://issues.apache.org/jira/browse/DRILL-6623?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16551400#comment-16551400 ]
Robert Hou edited comment on DRILL-6623 at 7/20/18 10:50 PM: ------------------------------------------------------------- A similar error message occurs when running this query on MapR Drill 1.13. The index value is the same, so it is possible that the error message was changed in Apache Drill 1.14. [#14] Query failed: oadd.org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IndexOutOfBoundsException: index: -8373248, length: 0 (expected: range(0, 32768)) Fragment 0:0 [Error Id: b3a702b8-1a46-4e8c-8d86-a7d4bda88acd on qa-node186.qa.lab:31010] (java.lang.IndexOutOfBoundsException) index: -8373248, length: 0 (expected: range(0, 32768)) io.netty.buffer.AbstractByteBuf.checkIndex0():1125 io.netty.buffer.AbstractByteBuf.checkIndex():1120 io.netty.buffer.UnsafeByteBufUtil.setBytes():349 io.netty.buffer.PooledUnsafeDirectByteBuf.setBytes():199 io.netty.buffer.WrappedByteBuf.setBytes():397 io.netty.buffer.UnsafeDirectLittleEndian.setBytes():37 io.netty.buffer.DrillBuf.setBytes():767 org.apache.drill.exec.vector.VarCharVector$Mutator.setSafe():577 org.apache.drill.exec.vector.NullableVarCharVector$MutatorImpl.fillEmpties():929 org.apache.drill.exec.vector.NullableVarCharVector$MutatorImpl.setValueCount():1057 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.setValueCount():272 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork():205 org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():97 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():134 org.apache.drill.exec.record.AbstractRecordBatch.next():164 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():109 org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():134 org.apache.drill.exec.record.AbstractRecordBatch.next():164 org.apache.drill.exec.physical.impl.BaseRootExec.next():105 org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():83 org.apache.drill.exec.physical.impl.BaseRootExec.next():95 org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():233 org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226 java.security.AccessController.doPrivileged():-2 javax.security.auth.Subject.doAs():422 org.apache.hadoop.security.UserGroupInformation.doAs():1633 org.apache.drill.exec.work.fragment.FragmentExecutor.run():226 org.apache.drill.common.SelfCleaningRunnable.run():38 java.util.concurrent.ThreadPoolExecutor.runWorker():1149 java.util.concurrent.ThreadPoolExecutor$Worker.run():624 java.lang.Thread.run():748 at oadd.org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123) at oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:422) at oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:96) at oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274) at oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244) at oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:88) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:287) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:312) at oadd.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:286) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1294) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:911) at oadd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645) at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) at oadd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) at oadd.io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131) at java.lang.Thread.run(Thread.java:748) was (Author: rhou): A similar error message occurs when running this query on MapR Drill 1.13. [#14] Query failed: oadd.org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IndexOutOfBoundsException: index: -8373248, length: 0 (expected: range(0, 32768)) Fragment 0:0 [Error Id: b3a702b8-1a46-4e8c-8d86-a7d4bda88acd on qa-node186.qa.lab:31010] (java.lang.IndexOutOfBoundsException) index: -8373248, length: 0 (expected: range(0, 32768)) io.netty.buffer.AbstractByteBuf.checkIndex0():1125 io.netty.buffer.AbstractByteBuf.checkIndex():1120 io.netty.buffer.UnsafeByteBufUtil.setBytes():349 io.netty.buffer.PooledUnsafeDirectByteBuf.setBytes():199 io.netty.buffer.WrappedByteBuf.setBytes():397 io.netty.buffer.UnsafeDirectLittleEndian.setBytes():37 io.netty.buffer.DrillBuf.setBytes():767 org.apache.drill.exec.vector.VarCharVector$Mutator.setSafe():577 org.apache.drill.exec.vector.NullableVarCharVector$MutatorImpl.fillEmpties():929 org.apache.drill.exec.vector.NullableVarCharVector$MutatorImpl.setValueCount():1057 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.setValueCount():272 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork():205 org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():97 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():134 org.apache.drill.exec.record.AbstractRecordBatch.next():164 org.apache.drill.exec.record.AbstractRecordBatch.next():119 org.apache.drill.exec.record.AbstractRecordBatch.next():109 org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():134 org.apache.drill.exec.record.AbstractRecordBatch.next():164 org.apache.drill.exec.physical.impl.BaseRootExec.next():105 org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():83 org.apache.drill.exec.physical.impl.BaseRootExec.next():95 org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():233 org.apache.drill.exec.work.fragment.FragmentExecutor$1.run():226 java.security.AccessController.doPrivileged():-2 javax.security.auth.Subject.doAs():422 org.apache.hadoop.security.UserGroupInformation.doAs():1633 org.apache.drill.exec.work.fragment.FragmentExecutor.run():226 org.apache.drill.common.SelfCleaningRunnable.run():38 java.util.concurrent.ThreadPoolExecutor.runWorker():1149 java.util.concurrent.ThreadPoolExecutor$Worker.run():624 java.lang.Thread.run():748 at oadd.org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123) at oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:422) at oadd.org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:96) at oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:274) at oadd.org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:244) at oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:88) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:287) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:312) at oadd.io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:286) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) at oadd.io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1294) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) at oadd.io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) at oadd.io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:911) at oadd.io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645) at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580) at oadd.io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497) at oadd.io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459) at oadd.io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131) at java.lang.Thread.run(Thread.java:748) > Drill encounters exception IndexOutOfBoundsException: writerIndex: -8373248 > (expected: readerIndex(0) <= writerIndex <= capacity(32768)) > ---------------------------------------------------------------------------------------------------------------------------------------- > > Key: DRILL-6623 > URL: https://issues.apache.org/jira/browse/DRILL-6623 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Relational Operators > Affects Versions: 1.14.0 > Reporter: Robert Hou > Assignee: Pritesh Maker > Priority: Major > Attachments: 24aedae9-d1f3-8e12-2e1f-0479915c61b1.sys.drill, > drillbit.log.61b1 > > > This is the query: > alter session set `planner.width.max_per_node` = 1; > alter session set `planner.width.max_per_query` = 1; > select * from ( > select > split_part(CharacterValuea, '8', 1) CharacterValuea, > split_part(CharacterValueb, '8', 1) CharacterValueb, > split_part(CharacterValuec, '8', 2) CharacterValuec, > split_part(CharacterValued, '8', 3) CharacterValued, > split_part(CharacterValuee, 'b', 1) CharacterValuee > from (select * from > dfs.`/drill/testdata/batch_memory/character5_1MB_1GB.parquet` order by > CharacterValuea) d where d.CharacterValuea = '1234567890123110'); > The query works with a smaller table. > This is the stack trace: > {noformat} > 2018-07-19 16:59:48,803 [24aedae9-d1f3-8e12-2e1f-0479915c61b1:frag:0:0] ERROR > o.a.d.e.w.fragment.FragmentExecutor - SYSTEM ERROR: > IndexOutOfBoundsException: writerIndex: -8373248 (expected: readerIndex(0) <= > writerIndex <= capacity(32768)) > Fragment 0:0 > [Error Id: edc75560-41ca-4fdd-907f-060be1795786 on qa-node186.qa.lab:31010] > org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: > IndexOutOfBoundsException: writerIndex: -8373248 (expected: readerIndex(0) <= > writerIndex <= capacity(32768)) > Fragment 0:0 > [Error Id: edc75560-41ca-4fdd-907f-060be1795786 on qa-node186.qa.lab:31010] > at > org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:633) > ~[drill-common-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.sendFinalState(FragmentExecutor.java:361) > [drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup(FragmentExecutor.java:216) > [drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:327) > [drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.common.SelfCleaningRunnable.run(SelfCleaningRunnable.java:38) > [drill-common-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) > [na:1.8.0_161] > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > [na:1.8.0_161] > at java.lang.Thread.run(Thread.java:748) [na:1.8.0_161] > Caused by: java.lang.IndexOutOfBoundsException: writerIndex: -8373248 > (expected: readerIndex(0) <= writerIndex <= capacity(32768)) > at > io.netty.buffer.AbstractByteBuf.writerIndex(AbstractByteBuf.java:104) > ~[netty-buffer-4.0.48.Final.jar:4.0.48.Final] > at > org.apache.drill.exec.vector.VarCharVector$Mutator.setValueCount(VarCharVector.java:810) > ~[vector-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.vector.NullableVarCharVector$Mutator.setValueCount(NullableVarCharVector.java:641) > ~[vector-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.setValueCount(ProjectRecordBatch.java:329) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork(ProjectRecordBatch.java:242) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:117) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:142) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:172) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:109) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.record.AbstractUnaryRecordBatch.innerNext(AbstractUnaryRecordBatch.java:63) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext(ProjectRecordBatch.java:142) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:172) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:103) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext(ScreenCreator.java:83) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:93) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:294) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at > org.apache.drill.exec.work.fragment.FragmentExecutor$1.run(FragmentExecutor.java:281) > ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > at java.security.AccessController.doPrivileged(Native Method) > ~[na:1.8.0_161] > at javax.security.auth.Subject.doAs(Subject.java:422) ~[na:1.8.0_161] > at > org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1595) > ~[hadoop-common-2.7.0-mapr-1707.jar:na] > at > org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:281) > [drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT] > ... 4 common frames omitted > {noformat} > This is the explain plan: > {noformat} > | 00-00 Screen : rowType = RecordType(ANY CharacterValuea, ANY > CharacterValueb, ANY CharacterValuec, ANY CharacterValued, ANY > CharacterValuee): rowcount = 9216000.0, cumulative cost = {5.815296E8 rows, > 8.786270178575306E9 cpu, 0.0 io, 1.00663296E12 network, 9.8304E8 memory}, id > = 3374 > 00-01 ProjectAllowDup(CharacterValuea=[$0], CharacterValueb=[$1], > CharacterValuec=[$2], CharacterValued=[$3], CharacterValuee=[$4]) : rowType = > RecordType(ANY CharacterValuea, ANY CharacterValueb, ANY CharacterValuec, ANY > CharacterValued, ANY CharacterValuee): rowcount = 9216000.0, cumulative cost > = {5.80608E8 rows, 8.785348578575306E9 cpu, 0.0 io, 1.00663296E12 network, > 9.8304E8 memory}, id = 3373 > 00-02 Project(CharacterValuea=[SPLIT_PART(ITEM($0, 'CharacterValuea'), > '8', 1)], CharacterValueb=[SPLIT_PART(ITEM($0, 'CharacterValueb'), '8', 1)], > CharacterValuec=[SPLIT_PART(ITEM($0, 'CharacterValuec'), '8', 2)], > CharacterValued=[SPLIT_PART(ITEM($0, 'CharacterValued'), '8', 3)], > CharacterValuee=[SPLIT_PART(ITEM($0, 'CharacterValuee'), 'b', 1)]) : rowType > = RecordType(ANY CharacterValuea, ANY CharacterValueb, ANY CharacterValuec, > ANY CharacterValued, ANY CharacterValuee): rowcount = 9216000.0, cumulative > cost = {5.71392E8 rows, 8.739268578575306E9 cpu, 0.0 io, 1.00663296E12 > network, 9.8304E8 memory}, id = 3372 > 00-03 SelectionVectorRemover : rowType = RecordType(DYNAMIC_STAR > T3¦¦**): rowcount = 9216000.0, cumulative cost = {5.62176E8 rows, > 8.554948578575305E9 cpu, 0.0 io, 1.00663296E12 network, 9.8304E8 memory}, id > = 3371 > 00-04 Filter(condition=[=(ITEM($0, 'CharacterValuea'), > '1234567890123110')]) : rowType = RecordType(DYNAMIC_STAR T3¦¦**): rowcount = > 9216000.0, cumulative cost = {5.5296E8 rows, 8.545732578575305E9 cpu, 0.0 io, > 1.00663296E12 network, 9.8304E8 memory}, id = 3370 > 00-05 Project(T3¦¦**=[$0]) : rowType = RecordType(DYNAMIC_STAR > T3¦¦**): rowcount = 6.144E7, cumulative cost = {4.9152E8 rows, > 8.263108578575305E9 cpu, 0.0 io, 1.00663296E12 network, 9.8304E8 memory}, id > = 3369 > 00-06 SingleMergeExchange(sort0=[1]) : rowType = > RecordType(DYNAMIC_STAR T3¦¦**, ANY CharacterValuea): rowcount = 6.144E7, > cumulative cost = {4.3008E8 rows, 8.201668578575305E9 cpu, 0.0 io, > 1.00663296E12 network, 9.8304E8 memory}, id = 3368 > 01-01 OrderedMuxExchange(sort0=[1]) : rowType = > RecordType(DYNAMIC_STAR T3¦¦**, ANY CharacterValuea): rowcount = 6.144E7, > cumulative cost = {3.6864E8 rows, 7.710148578575305E9 cpu, 0.0 io, > 5.0331648E11 network, 9.8304E8 memory}, id = 3367 > 02-01 SelectionVectorRemover : rowType = > RecordType(DYNAMIC_STAR T3¦¦**, ANY CharacterValuea): rowcount = 6.144E7, > cumulative cost = {3.072E8 rows, 7.648708578575305E9 cpu, 0.0 io, > 5.0331648E11 network, 9.8304E8 memory}, id = 3366 > 02-02 Sort(sort0=[$1], dir0=[ASC]) : rowType = > RecordType(DYNAMIC_STAR T3¦¦**, ANY CharacterValuea): rowcount = 6.144E7, > cumulative cost = {2.4576E8 rows, 7.587268578575305E9 cpu, 0.0 io, > 5.0331648E11 network, 9.8304E8 memory}, id = 3365 > 02-03 HashToRandomExchange(dist0=[[$1]]) : rowType = > RecordType(DYNAMIC_STAR T3¦¦**, ANY CharacterValuea): rowcount = 6.144E7, > cumulative cost = {1.8432E8 rows, 1.2288E9 cpu, 0.0 io, 5.0331648E11 network, > 0.0 memory}, id = 3364 > 03-01 Project(T3¦¦**=[$0], CharacterValuea=[$1]) : > rowType = RecordType(DYNAMIC_STAR T3¦¦**, ANY CharacterValuea): rowcount = > 6.144E7, cumulative cost = {1.2288E8 rows, 2.4576E8 cpu, 0.0 io, 0.0 network, > 0.0 memory}, id = 3363 > 03-02 Scan(groupscan=[ParquetGroupScan > [entries=[ReadEntryWithPath > [path=maprfs:///drill/testdata/batch_memory/character5_1MB_1GB.parquet]], > selectionRoot=maprfs:/drill/testdata/batch_memory/character5_1MB_1GB.parquet, > numFiles=1, numRowGroups=25, usedMetadataFile=false, columns=[`**`]]]) : > rowType = RecordType(DYNAMIC_STAR **, ANY CharacterValuea): rowcount = > 6.144E7, cumulative cost = {6.144E7 rows, 1.2288E8 cpu, 0.0 io, 0.0 network, > 0.0 memory}, id = 3362 > {noformat} > The table can be found in /home/MAPRTECH/qa/rhou/drill6623. > I have attached the profile and the drillbit.log. > This was encountered on the Apache Drill release with the latest code in July > 19. This is the commit id: > | 1.14.0-SNAPSHOT | 85344abd1ddb73448bdf67cdc6883cb98795a910 | DRILL-6614: > Allow usage of MapRDBFormatPlugin for HiveStoragePlugin | 19.07.2018 @ > 10:39:36 PDT | r...@mapr.com | 19.07.2018 @ 15:44:52 PDT | -- This message was sent by Atlassian JIRA (v7.6.3#76005)