AnsweredAssumed Answered

Query is always throwing IndexOutOfBoundsException if I try to retrieve more columns

Question asked by skalapa on May 11, 2018
Latest reply on May 11, 2018 by maprcommunity



I am always getting IndexOutOfBoundsException for the queries when I try to retrieve more columns. 


I am using MapR-Sandbox-For-Apache-Drill-1.13.0-6.0.1 of sandbox as I was advised to install mep 4.0 package for 

 MapR-Sandbox-For-Apache-Drill-1.11.0-6.0.0 . But even after upgrading there is no way am able to query for more columns .

1) Does it depend on the length of the column name or if it the nested structure ?

2) It works sometimes on MapR-Sandbox-For-Apache-Drill-1.11.0-6.0.0 but on the new version it always throws this error.


Not understanding the root cause of this inconsistency of the drill.


Please guide me through some solution so that I can keep this version for futher process . Or should I go back to previous version ?


Note: I have already cleaned the logs and then restarted .


Error Message is as below:

org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IndexOutOfBoundsException: index: 0, length: 4 (expected: range(0, 0)) Fragment 0:0 [Error Id: 76ea9bcd-f2c5-4774-ba61-53ec5895853a on] (java.lang.IndexOutOfBoundsException) index: 0, length: 4 (expected: range(0, 0)) io.netty.buffer.DrillBuf.checkIndexD():122 io.netty.buffer.DrillBuf.chk():146 io.netty.buffer.DrillBuf.getInt():523 org.apache.drill.exec.vector.UInt4Vector$Accessor.get():438 org.apache.drill.exec.vector.complex.ListVector$Mutator.startNewValue():304 org.apache.drill.exec.vector.complex.impl.UnionListWriter.startList():460 org.apache.drill.exec.vector.complex.impl.AbstractPromotableFieldWriter.startList():121 org.apache.drill.exec.vector.complex.impl.PromotableWriter.startList():41 org.apache.drill.exec.vector.complex.impl.MapOrListWriterImpl.start():68 org.apache.drill.exec.physical.impl.ScanBatch.internalNext():229 org.apache.drill.exec.record.AbstractSingleRecordBatch.innerNext():51 org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.innerNext():134 org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.innerNext():83$$ java.util.concurrent.ThreadPoolExecutor.runWorker():1142 java.util.concurrent.ThreadPoolExecutor$