[jira] [Commented] (DRILL-2875) IllegalStateException when querying the public yelp json dataset

["Steven Phillips (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14543125#comment-14543125 ] 

Steven Phillips commented on DRILL-2875:
----------------------------------------

Record number 10597 is this:

{"business_id": "2jXXBLPA6Qk1j6vOUXV9sQ", "full_address": "365 Convention Center Dr\nEastside\nLas Vegas, NV 89109", "hours": {}, "open": false, "categories": ["Nightlife"], "city": "Las Vegas", "review_count": 7, "name": "The Beach", "neighborhoods": ["Eastside"], "longitude": -115.155494, "state": "NV", "stars": 3.5, "latitude": 36.131763900000003, "attributes": {"Accepts Credit Cards": {}, "Music": {"dj": true, "background_music": false, "jukebox": false, "live": true, "video": false, "karaoke": false}, "Alcohol": "full_bar"}, "type": "business"}

Note specifically: "Accepts Credit Cards": {}

In the other records in this file, the "Accepts Credit Cards" field is a boolean, but here it is an empty map. 

It would be helpful to have a more helpful message here. I have a patch that will at least give the correct record number, as right now it displays the number relative to the current batch, which isn't helpful for finding the record in the file.

> IllegalStateException when querying the public yelp json dataset
> ----------------------------------------------------------------
>
>                 Key: DRILL-2875
>                 URL: https://issues.apache.org/jira/browse/DRILL-2875
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>            Reporter: Rahul Challapalli
>            Assignee: Steven Phillips
>            Priority: Critical
>             Fix For: 1.0.0
>
>         Attachments: error.log
>
>
> git.commit.id.abbrev=5cd36c5
> The below query fails from sqlline after displaying a few results
> {code}
>  select attributes from `json_kvgenflatten/yelp_academic_dataset_business.json`;
> .......after displaying fefw records .....
> 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)
> {code}
> I attached the error log and the data set. Let me know if you need anything else



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)