[
https://issues.apache.org/jira/browse/DRILL-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Parth Chandra resolved DRILL-2177.
----------------------------------
Resolution: Fixed
Appears to be fixed. Please verify.
> 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: Client - CLI
> Affects Versions: 0.8.0
> Reporter: Abhishek Girish
> Assignee: Parth Chandra
> Fix For: 0.9.0
>
> 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)
