[ https://issues.apache.org/jira/browse/DRILL-4443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15204059#comment-15204059 ]
Khurram Faraaz commented on DRILL-4443: --------------------------------------- Verified on MapR Drill 1.7.0-SNAPSHOT , commit ID : 245da979 Tests are added here under these test directories Functional/window_functions/frameclause/RBCRACR Functional/window_functions/frameclause/RBUPACR Functional/window_functions/frameclause/RBUPAUF > MIN/MAX on VARCHAR throw a NullPointerException > ----------------------------------------------- > > Key: DRILL-4443 > URL: https://issues.apache.org/jira/browse/DRILL-4443 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Flow > Affects Versions: 1.6.0 > Environment: 4 node cluster CentOS > Reporter: Khurram Faraaz > Assignee: Deneche A. Hakim > Priority: Critical > Fix For: 1.6.0 > > Attachments: DRILL_4443.parquet, test4443.csv > > > Using a simple csv file that contains at least 2 groups of rows: > {noformat} > a, > a, > a, > b, > {noformat} > Running a query with min/max throws a NullPointerException: > {noformat} > SELECT MIN(columns[1]) FROM `test4443.csv` GROUP BY columns[0]; > Error: SYSTEM ERROR: NullPointerException > ... > {noformat} > {noformat} > SELECT MAX(columns[1]) FROM `test4443.csv` GROUP BY columns[0]; > Error: SYSTEM ERROR: NullPointerException > ... > {noformat} > The problem is caused by {{VarCharAggrFunctions.java}} that is not reseting > it's internal buffer properly. -- This message was sent by Atlassian JIRA (v6.3.4#6332)