[DRILL-196] Some queries that should work throw strange exceptions.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.1.0-m1
• Assignee: Unassigned
• Reporter: Jacques Nadeau
• Created: 02/Sep/13 00:30
• Updated: 09/Oct/13 18:09
• Resolved: 04/Sep/13 11:40

Description

Other group by queries work. However, the one below fails. Not sure why. Error is on client side. Could be encoding or decoding of record batches.

SELECT _MAP['N_NAME'], count(1) FROM "/tmp/nation.parquet" group by _MAP['N_NAME'];

java.lang.IndexOutOfBoundsException: index: 7, length: 2 (expected: range(0, 7))
at io.netty.buffer.AbstractByteBuf.checkIndex(AbstractByteBuf.java:1130)
at io.netty.buffer.SlicedByteBuf.getBytes(SlicedByteBuf.java:171)
at org.apache.drill.exec.vector.VarBinaryVector$Accessor.get(VarBinaryVector.java:234)
at org.apache.drill.exec.vector.VarBinaryVector$Accessor.getObject(VarBinaryVector.java:251)
at org.apache.drill.sql.client.full.BatchLoaderMap.getObj(BatchLoaderMap.java:116)
at org.apache.drill.sql.client.full.BatchLoaderMap.getCurrentObject(BatchLoaderMap.java:108)
at org.apache.drill.sql.client.full.ResultEnumerator.moveNext(ResultEnumerator.java:34)
at net.hydromatic.optiq.runtime.ArrayEnumeratorCursor.next(ArrayEnumeratorCursor.java:44)
at net.hydromatic.optiq.jdbc.OptiqResultSet.next(OptiqResultSet.java:161)
at sqlline.SqlLine$BufferedRows.<init>(SqlLine.java:2499)
at sqlline.SqlLine.print(SqlLine.java:1886)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3835)
at sqlline.SqlLine$Commands.sql(SqlLine.java:3738)
at sqlline.SqlLine.dispatch(SqlLine.java:882)
at sqlline.SqlLine.begin(SqlLine.java:717)
at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460)
at sqlline.SqlLine.main(SqlLine.java:443)

Issue Links

• relates to: DRILL-205 SELECT DISTINCT fails on char column