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] [Created] (DRILL-1764) Count star returns invalid result
Date Fri, 21 Nov 2014 00:03:35 GMT
Hanifi Gunes created DRILL-1764:
-----------------------------------

             Summary: Count star returns invalid result
                 Key: DRILL-1764
                 URL: https://issues.apache.org/jira/browse/DRILL-1764
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Hanifi Gunes


@fc58c69 [current head]

Running a count star on yelp biz dataset

{code:sql}
SELECT count(*) FROM dfs.`/path/to/yelp-business.json`
{code}

yields *1,584* rows. However, running count on a specific field like so

{code:sql}
SELECT count(business_id) FROM dfs.`/path/to/yelp-business.json`
{code}

returns *15,585* rows as expected since the file has exact the same row count.

Running count star must return the exact number of records in the file.






--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message