arunkumarucet opened a new pull request, #16497: URL: https://github.com/apache/pinot/pull/16497
**This PR introduces support for the MINSTRING and MAXSTRING aggregation functions in Apache Pinot.** **The key features of this implementation are:** **Functionality**: **MINSTRING** and **MAXSTRING** calculate the minimum and maximum string values lexicographically, respectively, for a given column. **Null Handling**: The functions are built to handle null values and the string literal "null" gracefully. Both are ignored during aggregation if other valid string values are present. If all values are null or "null", the result is "null". **Aggregation Modes**: Support is included for single-value (SV) and multi-value (MV) dimensions, as well as both plain aggregation and group-by queries. **Error Handling**: The functions throw a BadQueryRequestException if they are used on a numeric column. **Testing**: Comprehensive unit and integration tests have been added to validate the behavior across various scenarios, including different null handling settings and group-by aggregations. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
