[DRILL-205] SELECT DISTINCT fails on char column

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.1.0-m1

Environment

drill-root-1.0.0-m1

• Assignee: Ben Becker
• Reporter: Harri Kinnunen
• Created: 04/Sep/13 16:03
• Updated: 09/Oct/13 18:09
• Resolved: 05/Sep/13 17:28

Description

This works:
SELECT distinct nation.name
FROM (
SELECT _MAP['N_REGIONKEY'] as name
FROM "sample-data/nation.parquet"
) nation;

This fails (the difference is the 'N_NAME'):
SELECT distinct nation.name
FROM (
SELECT _MAP['N_NAME'] as name
FROM "sample-data/nation.parquet"
) nation;

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:97)
at org.apache.drill.sql.client.full.ResultEnumerator.moveNext(ResultEnumerator.java:34)
at net.hydromatic.optiq.runtime.ObjectEnumeratorCursor.next(ObjectEnumeratorCursor.java:44)
at net.hydromatic.optiq.jdbc.OptiqResultSet.next(OptiqResultSet.java:162)
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

• is related to: DRILL-196 Some queries that should work throw strange exceptions.
• requires: DRILL-209 Build is broken due to incorrect dependency versions of drill artifacts