Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
@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.