re20052 opened a new pull request, #64151:
URL: https://github.com/apache/doris/pull/64151
### What problem does this PR solve?
Problem Summary:
The current `SHOW ROUTINE LOAD TASK` statement only accepts a `WHERE`-based
syntax to specify the job:
SHOW ROUTINE LOAD TASK [FROM|IN <db>] WHERE JobName = "xxx"
This is inconsistent with other routine-load related statements, which all
use the shorter `FOR` form, e.g. `SHOW ROUTINE LOAD FOR <job>`, `STOP ROUTINE
LOAD FOR <job>`, `PAUSE ROUTINE LOAD FOR <job>`, `RESUME ROUTINE LOAD FOR
<job>`. The `WHERE JobName = "xxx"` form is verbose and rarely seen in
load-related grammar.
This PR adds the `FOR` clause to `SHOW ROUTINE LOAD TASK` to align with the
rest of the routine-load syntax:
SHOW ROUTINE LOAD TASK FOR <job_name>
SHOW ROUTINE LOAD TASK FOR <db>.<job_name>
The original `WHERE`-based syntax is fully preserved for backward
compatibility.
### Release note
Support `SHOW ROUTINE LOAD TASK FOR <job_name>` syntax.
### Check List (For Author)
- Test
- [x] Regression test
- Behavior changed:
- [x] Yes. Adds a new `FOR` clause to `SHOW ROUTINE LOAD TASK`. The
original `WHERE`-based syntax is preserved.
--
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]
