[
https://issues.apache.org/jira/browse/DRILL-1713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-1713:
----------------------------------
Fix Version/s: 0.7.0
Assignee: Hanifi Gunes
> 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
> Assignee: Hanifi Gunes
> Fix For: 0.7.0
>
>
> 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)
