You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/11/19 18:39:34 UTC
[jira] [Updated] (DRILL-1713) sqlline dumps core when querying
yelp JSON dataset
[ 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)