[DRILL-1713] sqlline dumps core when querying yelp JSON dataset

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Affects Version/s: 0.6.0
• Fix Version/s: 0.7.0
• Component/s: Client - CLI

Environment

Mac OS X, Drill 0.6.0, invoked as /opt/drill/bin/sqlline -u jdbc:drill:zk=local

• Assignee: Hanifi Gunes
• Reporter: Vince Gonzalez
• Created: 14/Nov/14 14:30
• Updated: 01/Dec/14 23:19
• Resolved: 01/Dec/14 23:19

Description

Dataset is 113MB of JSON from the yelp dataset challenge, data available here: http://www.yelp.com/dataset_challenge

sqlline crashes many lines into the output.

My query:

SELECT
CAST(t.votes.funny AS INT) AS funny,
CAST(t.votes.useful AS INT) AS useful,
CAST(t.votes.cool AS INT) AS cool,
t.user_id,
t.review_id,
CAST(t.stars AS INT) as stars,
t.`date`,
t.text,
t.type,
t.business_id
FROM dfs.`/Users/vince/Desktop/data/yelp/yelp_academic_dataset_review.json` AS t