SHOW CREATE ROUTINE LOAD

Description

This statement is used to display the creation statement of a routine load job.

The result shows the current consuming Kafka partitions and their corresponding offsets to be consumed. The result may not be a real-time consumption point, and should be based on the result of show routine load.

Syntax

SHOW [ALL] CREATE ROUTINE LOAD for <load_name>;

Required Parameters

1. <load_name>

The name of the routine load job

Optional Parameters

1. [ALL]

Optional parameter that represents retrieving all jobs, including historical jobs

Access Control Requirements

Users executing this SQL command must have at least the following permission:

Privilege	Object	Notes
LOAD_PRIV	Table	SHOW CREATE ROUTINE LOAD requires LOAD permission on the table

Examples

• Show the creation statement of a specified routine load job in the default database

  SHOW CREATE ROUTINE LOAD for test_load