Jim Scott created DRILL-1205:
--------------------------------
Summary: 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
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)
