SHOW-CREATE-ROUTINE-LOAD

SHOW CREATE ROUTINE LOAD

This statement is used to demonstrate the creation statement of a routine import job.

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;

illustrate:

ALL: optional parameter, which means to get all jobs, including historical jobs
load_name: routine import job name

Show the creation statement of the specified routine import job under the default db
```
SHOW CREATE ROUTINE LOAD for test_load
```

SHOW, CREATE, ROUTINE, LOAD

SHOW-CREATE-ROUTINE-LOAD​