[jira] [Commented] (DRILL-1205) group by causes access to DeadBuf

["Hanifi Gunes (JIRA)" <ji...@apache.org>]

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

Hanifi Gunes commented on DRILL-1205:
-------------------------------------

Please include the *.csv files or links to those.

> group by causes access to DeadBuf
> ---------------------------------
>
>                 Key: DRILL-1205
>                 URL: https://issues.apache.org/jira/browse/DRILL-1205
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Operators
>    Affects Versions: 1.0.0
>            Reporter: Jim Scott
>            Assignee: Hanifi Gunes
>
> Might be related to drill-922
> This runs just fine:
> select count(*) as incidents from dfs.`/tmp/Downloads/Crimes_-_2001_to_present.csv` where columns[3] in (SELECT columns[2] FROM dfs.`/tmp/Downloads/Sex_Offenders.csv`);
> This fails:
> select count(*) as incidents, columns[5] as type, columns[6] as subtype from dfs.`/tmp/Downloads/Crimes_-_2001_to_present.csv` 
> where columns[3] in (SELECT columns[2] FROM dfs.`/tmp/Downloads/Sex_Offenders.csv`)
> group by columns[6], columns[5]
> order by incidents desc limit 10;
> Error:
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "26218e5d-5748-43b9-bc77-ab82d9a1c509"
> endpoint {
>   address: "myserver"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while running fragment. < IndexOutOfBoundsException:[ index: 28388, length: 4 (expected: range(0, 28388)) ]"
> ]
> Error: exception while executing query (state=,code=0)
> 0: jdbc:drill:zk=local> Exception in thread "e5e6763f-6d42-42b8-9a75-e972c9cf90c2:frag:0:0 - Producer Thread" java.lang.UnsupportedOperationException: Attemped to access a DeadBuf. This would happen if you attempted to interact with a buffer that has been moved or not yet initialized.
> 	at org.apache.drill.exec.record.DeadBuf.capacity(DeadBuf.java:70)
> 	at org.apache.drill.exec.vector.UInt4Vector.getValueCapacity(UInt4Vector.java:106)
> 	at org.apache.drill.exec.vector.VarCharVector.getValueCapacity(VarCharVector.java:120)
> 	at org.apache.drill.exec.vector.RepeatedVarCharVector.getValueCapacity(RepeatedVarCharVector.java:113)
> 	at org.apache.drill.exec.vector.RepeatedVarCharVector$Mutator.startNewGroup(RepeatedVarCharVector.java:379)
> 	at org.apache.drill.exec.store.text.DrillTextRecordReader.next(DrillTextRecordReader.java:123)
> 	at org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:138)
> 	at org.apache.drill.exec.physical.impl.producer.ProducerConsumerBatch$Producer.run(ProducerConsumerBatch.java:122)
> 	at java.lang.Thread.run(Thread.java:745)



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