Vince Gonzalez created DRILL-1713:
-------------------------------------
Summary: sqlline dumps core when querying yelp JSON dataset
Key: DRILL-1713
URL: https://issues.apache.org/jira/browse/DRILL-1713
Project: Apache Drill
Issue Type: Bug
Components: Client - CLI
Affects Versions: 0.6.0
Environment: Mac OS X, Drill 0.6.0, invoked as /opt/drill/bin/sqlline
-u jdbc:drill:zk=local
Reporter: Vince Gonzalez
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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
