[DRILL-2177] Select * with Order by 1 fails on Yelp JSON dataset

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 0.9.0
• Component/s: Client - CLI
• Assignee: Parth Chandra
• Reporter: Abhishek Girish
• Created: 06/Feb/15 19:34
• Updated: 24/Apr/15 22:38
• Resolved: 09/Apr/15 19:15

Description

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.