Chris Westin created DRILL-3139: ----------------------------------- Summary: Query against yelp academic dataset causes exception Key: DRILL-3139 URL: https://issues.apache.org/jira/browse/DRILL-3139 Project: Apache Drill Issue Type: Bug Components: Client - CLI Affects Versions: 0.9.0 Environment: OSX Reporter: Chris Westin Assignee: Daniel Barclay (Drill)
I was following along the tutorial for "Analyzing the Yelp Academic Dataset." I tried the first query "Querying Yelp Business Data" WITHOUT the limit clause: select * from dfs.`/users/nrentachintala/Downloads/yelp/yelp_academic_dataset_business.json`; (Adjust for your own download path). A bunch of data comes out, followed by an exception: "Dietary Restrictions":{}} | business | null | 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) 0: jdbc:drill:zk=local> Note that this was tried against the 0.9.0 tarball referred to in the tutorials and download links. -- This message was sent by Atlassian JIRA (v6.3.4#6332)