SHOW CREATE ROUTINE LOAD

description

The statement is used to show the routine load job creation statement of user-defined.
The kafka partition and offset in the result show the currently consumed partition and the corresponding offset to be consumed.
grammar：
    SHOW [ALL] CREATE ROUTINE LOAD for load_name;
Description：
   `ALL`: optional，Is for getting all jobs, including history jobs
   `load_name`: routine load name

example

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

keyword

SHOW,CREATE,ROUTINE,LOAD