[ https://issues.apache.org/jira/browse/DRILL-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Westin updated DRILL-2177: -------------------------------- Component/s: (was: Execution - Codegen) Execution - Flow Target Version/s: 0.9.0 > Select * with Order by 1 fails on Yelp JSON dataset > ---------------------------------------------------- > > Key: DRILL-2177 > URL: https://issues.apache.org/jira/browse/DRILL-2177 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Flow > Affects Versions: 0.8.0 > Reporter: Abhishek Girish > Assignee: Chris Westin > Attachments: drillbit_order_by.log, explain_plan.txt > > > A simple select * with order by fails on the Yelp academic dataset. > > select * from dfs.`/data/json/yelp/yelp_academic_dataset_review.json` order > > by 1 limit 1; > +-------------+------------+------------+------------+------------+------------+------------+------------+ > | business_id | date | review_id | stars | text | type > | user_id | votes | > +-------------+------------+------------+------------+------------+------------+------------+------------+ > Query failed: RemoteRpcException: Failure while running fragment., Cleanup > before finished. 0 out of 1 streams have finished. [ > 54820fd7-a57c-4871-8b89-676c5a229959 on abhi8.qa.lab:31010 ] > [ 54820fd7-a57c-4871-8b89-676c5a229959 on abhi8.qa.lab:31010 ] > java.lang.RuntimeException: java.sql.SQLException: Failure while executing > query. > at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514) > ... > at sqlline.SqlLine.main(SqlLine.java:460) > > select * from dfs.`/data/json/yelp/yelp_academic_dataset_business.json` > > order by 1 limit 1; > +------------+-------------+------------+------------+--------------+------------+------------+------------+------------+---------------+------------+--------------+------------+------------+------------+ > | attributes | business_id | categories | city | full_address | hours > | latitude | longitude | name | neighborhoods | open | > review_count | stars | state | type | > +------------+-------------+------------+------------+--------------+------------+------------+------------+------------+---------------+------------+--------------+------------+------------+------------+ > Query failed: RemoteRpcException: Failure while running fragment., Attempted > to close accountor with 92 buffer(s) still allocatedfor QueryId: > 2b2aea0b-0a51-55fb-ecd9-10ec697787f7, MajorFragmentId: 0, MinorFragmentId: 0. > Total 92 allocation(s) of byte size(s): 512, 512, 512, 512, 512, 512, > 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, > 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, > 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, > 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, > 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, > 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, 512, at stack location: > > org.apache.drill.exec.memory.TopLevelAllocator$ChildAllocator.buffer(TopLevelAllocator.java:217) > org.apache.drill.exec.vector.NullableBitVector.allocateNew(NullableBitVector.java:162) > > org.apache.drill.exec.vector.complex.MapVector$MapTransferPair.<init>(MapVector.java:160) > > org.apache.drill.exec.physical.impl.TopN.TopNBatch.innerNext(TopNBatch.java:221)... > ... > java.lang.RuntimeException: java.sql.SQLException: Failure while executing > query. > Log attached. -- This message was sent by Atlassian JIRA (v6.3.4#6332)