DESCRIBE - Lindorm - Alibaba Cloud Documentation Center

Use DESCRIBE (or DESC) to display the details of a Flink job, including its status, runtime duration, and full SQL definition.

Engine and version

DESCRIBE applies to the stream engine only and requires version 3.1.8 or later.

To check the current engine version or upgrade, use the console. For upgrade steps, see Upgrade the minor engine version of an ApsaraDB for Lindorm instance.

Syntax

{ DESCRIBE | DESC } name

name is the name of the Flink job. To list all jobs in the current resource group, run SHOW JOBS.

Example

Display the details of the datagen_job job:

DESC datagen_job \G;

Output:

*************************** 1. row ***************************
       Query ID: datagen_job
         Job ID: 0021dcbf7633ed1b4c5a64a59591****
         Status: RUNNING
   Is Stoppable: false
     Start time: 1753952195254
       End time: -1
       Duration: 61348039
Max Parallelism: -1
        DelayMs: -1.0
            Sql:
  SET 'parallelism.default' = '6';
  CREATE TABLE datagen (
    f_sequence INT,
    f_random INT,
    f_random_str STRING,
    ts AS localtimestamp,
    WATERMARK FOR ts AS ts
  ) WITH (
    'connector' = 'datagen',

    'rows-per-second'='5',
    'fields.f_sequence.kind'='sequence',
    'fields.f_sequence.start'='1',
    'fields.f_sequence.end'='50000000',
    'fields.f_random.min'='1',
    'fields.f_random.max'='500',
    'fields.f_random_str.length'='10'
  );

  CREATE TABLE print_table (
    f_sequence INT,
    f_random INT,
    f_random_str STRING
    ) WITH (
    'connector' = 'print'
  );

  INSERT INTO print_table select f_sequence,f_random,f_random_str from datagen;

Append \G to display results in vertical format for easier reading.

Output fields

Field	Description
Query ID	The name of the Flink job, as specified in the `DESCRIBE` statement.
Job ID	The unique identifier assigned to the job by the stream engine.
Status	The current job status. Common values: `RUNNING`, `FINISHED`, `FAILED`, `CANCELED`.
Is Stoppable	Whether the job can be stopped with a savepoint. `false` means the job does not support savepoint-based stops.
Start time	The time the job started, as a Unix timestamp in milliseconds.
End time	The time the job ended, as a Unix timestamp in milliseconds. `-1` means the job is still running.
Duration	How long the job has been running, in milliseconds.
Max Parallelism	The maximum parallelism configured for the job. `-1` means no explicit limit is set.
DelayMs	The processing delay in milliseconds. `-1.0` means no delay data is available.
Sql	The full SQL definition submitted with the job.

What's next

To view job details without SQL, navigate to the Jobs page in the Lindorm console.
To list all jobs in the current resource group, use SHOW JOBS.