SHOW CREATE ROUTINE LOAD

description

1. The statement is used to show the routine load job creation statement of user-defined.

3. The kafka partition and offset in the result show the currently consumed partition and the corresponding offset to be consumed.

5. grammar：
6. SHOW [ALL] CREATE ROUTINE LOAD for load_name;

8. Description：
9. `ALL`: optional，Is for getting all jobs, including history jobs
10. `load_name`: routine load name

example

1. 1. Show the creation statement of the specified routine load under the default db
2. SHOW CREATE ROUTINE LOAD for test_load

keyword

1. SHOW,CREATE,ROUTINE,LOAD