[ 
https://issues.apache.org/jira/browse/DRILL-844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14012532#comment-14012532
 ] 

Jacques Nadeau commented on DRILL-844:
--------------------------------------

Can you please give a length distribution of the file you are querying?  E.g., 
what is min, max, median and avg length of each column.

> hit java.lang.IndexOutOfBoundsException while querying some large data set
> --------------------------------------------------------------------------
>
>                 Key: DRILL-844
>                 URL: https://issues.apache.org/jira/browse/DRILL-844
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>            Reporter: Vivian Summers
>            Priority: Blocker
>
> 0: jdbc:drill:schema=dfs> SELECT columns[13] from `/user/root/cust-d1.tsv` 
> where columns[13] like '%noticias%';
> +------------+
> |   EXPR$0   |
> +------------+
> java.lang.IndexOutOfBoundsException
>       at io.netty.buffer.EmptyByteBuf.checkIndex(EmptyByteBuf.java:857)
>       at io.netty.buffer.EmptyByteBuf.getBytes(EmptyByteBuf.java:321)
>       at 
> org.apache.drill.exec.vector.VarCharVector$Accessor.get(VarCharVector.java:325)
>       at 
> org.apache.drill.exec.vector.VarCharVector$Accessor.getObject(VarCharVector.java:345)
>       at 
> org.apache.drill.exec.vector.accessor.VarCharAccessor.getObject(VarCharAccessor.java:94)
>       at 
> org.apache.drill.jdbc.AvaticaDrillSqlAccessor.getObject(AvaticaDrillSqlAccessor.java:136)
>       at 
> net.hydromatic.avatica.AvaticaResultSet.getObject(AvaticaResultSet.java:336)
>       at sqlline.SqlLine$Rows$Row.<init>(SqlLine.java:2388)
>       at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2504)
>       at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
>       at sqlline.SqlLine.print(SqlLine.java:1809)
>       at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
>       at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
>       at sqlline.SqlLine.dispatch(SqlLine.java:889)
>       at sqlline.SqlLine.begin(SqlLine.java:763)
>       at sqlline.SqlLine.start(SqlLine.java:498)
>       at sqlline.SqlLine.main(SqlLine.java:460)
> no error in Lilith
> It will hang in sqlline if you just run select columns[13] from 
> `/user/root/cust-d1.tsv` ;
> I have the data set and just ask for location for it.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to