[
https://issues.apache.org/jira/browse/DRILL-1614?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Abhishek Girish updated DRILL-1614:
-----------------------------------
Attachment: drillbit.log
Currently hitting a slightly different error. Log file attached.
Running any CTAS statement throws the following error on SQLLine
> create table customer as select * from
> dfs.`/tpcds/text/scale3000/customer/customer.dat`;
+------------+---------------------------+
| Fragment | Number of records written |
+------------+---------------------------+
| 1_0 | 461256 |
Query failed: Failure while running fragment., Attempted to close accountor
with 3 buffer(s) still allocatedfor QueryId:
e038a094-2e7e-4246-ad68-a98b5b66a7e9, MajorFragmentId: 1, MinorFragmentId: 0.
Total 1 allocation(s) of byte size(s): 8, at stack location:
org.apache.drill.exec.memory.TopLevelAllocator$ChildAllocator.buffer(TopLevelAllocator.java:212)
org.apache.drill.exec.vector.UInt4Vector.allocateNew(UInt4Vector.java:149)
org.apache.drill.exec.vector.VarCharVector.allocateNew(VarCharVector.java:333)
org.apache.drill.exec.vector.AllocationHelper.allocatePrecomputedChildCount(AllocationHelper.java:31)
org.apache.drill.exec.vector.AllocationHelper.allocate(AllocationHelper.java:42)
org.apache.drill.exec.vector.AllocationHelper.allocate(AllocationHelper.java:24)
org.apache.drill.exec.physical.impl.WriterRecordBatch.innerNext(WriterRecordBatch.java:141)
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:106)
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:124)
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:67)
org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec.innerNext(SingleSenderCreator.java:123)
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:57)
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:105)
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
java.lang.Thread.run(Thread.java:745)
Total 1 allocation(s) of byte size(s): 50, at stack location:
org.apache.drill.exec.memory.TopLevelAllocator$ChildAllocator.buffer(TopLevelAllocator.java:212)
org.apache.drill.exec.vector.VarCharVector.allocateNew(VarCharVector.java:330)
org.apache.drill.exec.vector.AllocationHelper.allocatePrecomputedChildCount(AllocationHelper.java:31)
org.apache.drill.exec.vector.AllocationHelper.allocate(AllocationHelper.java:42)
org.apache.drill.exec.vector.AllocationHelper.allocate(AllocationHelper.java:24)
org.apache.drill.exec.physical.impl.WriterRecordBatch.innerNext(WriterRecordBatch.java:141)
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:106)
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:124)
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:67)
org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec.innerNext(SingleSenderCreator.java:123)
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:57)
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:105)
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
java.lang.Thread.run(Thread.java:745)
Total 1 allocation(s) of byte size(s): 8, at stack location:
org.apache.drill.exec.memory.TopLevelAllocator$ChildAllocator.buffer(TopLevelAllocator.java:212)
org.apache.drill.exec.vector.BigIntVector.allocateNew(BigIntVector.java:149)
org.apache.drill.exec.vector.AllocationHelper.allocatePrecomputedChildCount(AllocationHelper.java:29)
org.apache.drill.exec.vector.AllocationHelper.allocate(AllocationHelper.java:42)
org.apache.drill.exec.vector.AllocationHelper.allocate(AllocationHelper.java:24)
org.apache.drill.exec.physical.impl.WriterRecordBatch.innerNext(WriterRecordBatch.java:144)
org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:106)
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:124)
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:67)
org.apache.drill.exec.physical.impl.SingleSenderCreator$SingleSenderRootExec.innerNext(SingleSenderCreator.java:123)
org.apache.drill.exec.physical.impl.BaseRootExec.next(BaseRootExec.java:57)
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:105)
org.apache.drill.exec.work.WorkManager$RunnableWrapper.run(WorkManager.java:249)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
java.lang.Thread.run(Thread.java:745)
[ 488b06e2-46c5-4432-ad0f-2d9b846b1b59 on abhi5.qa.lab:31010 ]
java.lang.RuntimeException: java.sql.SQLException: Failure while executing
query.
at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
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)
> CTAS is broken - throws RuntimeException and Reader error
> ---------------------------------------------------------
>
> Key: DRILL-1614
> URL: https://issues.apache.org/jira/browse/DRILL-1614
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Abhishek Girish
> Assignee: Parth Chandra
> Priority: Critical
> Attachments: drillbit.log
>
>
> CTAS is broken
> Create table as statements fail with the below error:
> Query failed: Failure while running fragment.
> java.lang.RuntimeException: java.sql.SQLException: Failure while executing
> query.
> at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> 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)
> LOG:
> 2014-10-29 16:24:20,236 [f9e93ef8-20c8-46da-9675-5384269f8c21:frag:0:0] WARN
> o.a.d.e.vector.complex.fn.JsonReader - Error reported. Quit writing
> 2014-10-29 16:24:20,413 [f9e93ef8-20c8-46da-9675-5384269f8c21:frag:0:0] WARN
> o.a.d.e.w.fragment.FragmentExecutor - Error while initializing or executing
> fragment
> The first CTAS statement usually succeeds and all subsequent statements fail.
> Tried on JSON and Text
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
