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

MIN/MAX on VARCHAR throw a NullPointerException

    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. test4443.csv
          0.0 kB
          Abdel Hakim Deneche
        2. DRILL_4443.parquet
          12 kB
          Khurram Faraaz

        Activity

          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: