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

Reply via email to