drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Parth Chandra (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2177) Select * with Order by 1 fails on Yelp JSON dataset
Date Mon, 23 Feb 2015 18:05:23 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Parth Chandra updated DRILL-2177:
---------------------------------
    Fix 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: Client - CLI
>    Affects Versions: 0.8.0
>            Reporter: Abhishek Girish
>            Assignee: Chris Westin
>             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)

Mime
View raw message