[ https://issues.apache.org/jira/browse/DRILL-3139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14549486#comment-14549486 ]
Steven Phillips commented on DRILL-3139: ---------------------------------------- That file contains a record which Drill is unable to parse. If you run the current release candidate, you will see this message: java.lang.RuntimeException: java.sql.SQLException: DATA_READ ERROR: Error parsing JSON - You tried to start when you are using a ValueWriter of type NullableBitWriterImpl. File /Users/sphillips/yelp/yelp_academic_dataset_business.json Record 10597 Fragment 0:0 [Error Id: d3f9eb54-970a-4bc8-9bfc-487c27a1d619 on localhost:31010] at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73) at sqlline.TableOutputFormat$ResizingRowsProvider.next(TableOutputFormat.java:85) at sqlline.TableOutputFormat.print(TableOutputFormat.java:116) at sqlline.SqlLine.print(SqlLine.java:1583) at sqlline.Commands.execute(Commands.java:852) at sqlline.Commands.sql(Commands.java:751) at sqlline.SqlLine.dispatch(SqlLine.java:738) at sqlline.SqlLine.begin(SqlLine.java:612) at sqlline.SqlLine.start(SqlLine.java:366) at sqlline.SqlLine.main(SqlLine.java:259) The error message could still be improved, but at least now it shows which record is failing to parse. > 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)