Toms1999 opened a new pull request, #40938: URL: https://github.com/apache/doris/pull/40938
### Background In order to improve the usability of the `SHOW ROUTINE LOAD` command, we have added support for `ORDER BY` and `LIMIT` expressions. This enhancement will allow users to filter and sort routine load tasks more effectively. ### Changes - Implemented `ORDER BY` functionality to sort routine load tasks based on specified columns (e.g., ID, Name, etc.). - Added `LIMIT` expression to restrict the number of routine load tasks returned by the query. - Updated corresponding SQL parsing logic to handle these expressions. ### Impact This enhancement improves the flexibility of `SHOW ROUTINE LOAD` queries, making it easier to manage routine loads in large environments. Users can now quickly identify specific tasks using sorting and limiting mechanisms. ### Testing - Unit tests added for the new `ORDER BY` and `LIMIT` functionality. - Verified that the changes do not affect existing behavior when `ORDER BY` and `LIMIT` are not used. - Manual testing performed on a local environment to ensure expected functionality. -- 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: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
