Harri Kinnunen created DRILL-205:
------------------------------------
Summary: SELECT DISTINCT fails on char column
Key: DRILL-205
URL: https://issues.apache.org/jira/browse/DRILL-205
Project: Apache Drill
Issue Type: Bug
Reporter: Harri Kinnunen
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)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira