[
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)
