DESC INSTANCE-MaxCompute(MaxCompute)-阿里云帮助中心

Retrieves job information for a specified instance ID, including the SQL query, owner, start time, end time, and status.

Syntax

desc instance <instance_id>;

Parameters

Parameter	Description
`instance_id`	The ID of an instance. Each instance ID is unique.

Examples

-- Query job information for the instance whose ID is 20150715xxxxxxxxxxxxxxx.
desc instance 20150715xxxxxxxxxxxxxxx;

The following result is returned:

ID                                      20150715xxxxxxxxxxxxxxx
Owner                                   ALIYUN$XXXXXX@alibaba-inc.com
StartTime                               2015-07-15 18:34:41
EndTime                                 2015-07-15 18:34:42
Status                                  Terminated
console_select_query_task_1436956481295 Success
Query                                   select * from mj_test;

Related topics

Use the following statements to get more information about an instance or act on it:

Statement	Use case
SHOW commands	View instance information including StartTime (accurate to the second), RunTime (in seconds), Status, InstanceID, Owner, and the query statement.
STATUS	View the status of a specified instance.
TOP INSTANCE	View information about instances currently running in a project.
KILL	Stop a specific instance.
WAIT	Retrieve the operational log of a job by instance ID, including the Logview URL.