SHOW-CREATE-ROUTINE-LOAD

Name

SHOW CREATE ROUTINE LOAD

Description

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:

  1. SHOW [ALL] CREATE ROUTINE LOAD for load_name;

illustrate:

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

Example

  1. Show the creation statement of the specified routine import job under the default db

    1. SHOW CREATE ROUTINE LOAD for test_load

Keywords

  1. SHOW, CREATE, ROUTINE, LOAD

Best Practice