drill-issues 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

SELECT count(*) FROM dfs.`/path/to/yelp-business.json`

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

SELECT count(business_id) FROM dfs.`/path/to/yelp-business.json`

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

View raw message