drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hanifi Gunes (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-1713) sqlline dumps core when querying yelp JSON dataset
Date Mon, 01 Dec 2014 23:20:12 GMT

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

Mime
View raw message