[jira] [Resolved] (DRILL-1713) sqlline dumps core when querying yelp JSON dataset

["Hanifi Gunes (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Hanifi Gunes resolved DRILL-1713.
---------------------------------
    Resolution: Cannot Reproduce

The query above runs fine at a60e1db. I am able to see records being dumped even after repetitive runs. Please re-open if appears.

{panel:title=excerpt from sqlline}
...
335,022 rows selected (14.162 seconds)
0: jdbc:drill:> 
{panel}

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