Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1764

Count star returns invalid result

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.7.0
    • 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.

      Attachments

        1. DRILL-1764.1.patch.txt
          10 kB
          Hanifi Gunes

        Activity

          People

            hgunes Hanifi Gunes
            hgunes Hanifi Gunes
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: