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

MIN/MAX on VARCHAR throw a NullPointerException

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Fixed
    • 1.6.0
    • 1.6.0
    • Execution - Flow
    • None
    • 4 node cluster CentOS

    Description

      Using a simple csv file that contains at least 2 groups of rows:

      a,
      a,
      a,
      b,
      

      Running a query with min/max throws a NullPointerException:

      SELECT MIN(columns[1]) FROM `test4443.csv` GROUP BY columns[0];
      Error: SYSTEM ERROR: NullPointerException
      ...
      
      SELECT MAX(columns[1]) FROM `test4443.csv` GROUP BY columns[0];
      Error: SYSTEM ERROR: NullPointerException
      ...
      

      The problem is caused by VarCharAggrFunctions.java that is not reseting it's internal buffer properly.

      Attachments

        1. DRILL_4443.parquet
          12 kB
          Khurram Faraaz
        2. test4443.csv
          0.0 kB
          Abdel Hakim Deneche

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            adeneche Abdel Hakim Deneche
            khfaraaz Khurram Faraaz
            Khurram Faraaz Khurram Faraaz
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment