drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vince Gonzalez (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1713) sqlline dumps core when querying yelp JSON dataset
Date Fri, 14 Nov 2014 14:31:34 GMT
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)

Mime
View raw message