DESCRIBE TASK¶

语法¶

DESC[RIBE] TASK <name>

参数¶

name

指定要描述的任务的标识符。如果标识符包含空格或特殊字符，则整个字符串必须放在双引号内。放在双引号内的标识符也区分大小写。

输出¶

The command provides the same output as SHOW_TASKS.

使用说明¶

• 仅返回任务所有者（即对任务具有 OWNERSHIP 权限的角色）:emph:或者 对任务具有 MONITOR 或 OPERATE 权限的角色的行。

• To post-process the output of this command, you can use the pipe operator (->>) or the RESULT_SCAN function. Both constructs treat the output as a result set that you can query.

  The output column names for this command are generated in lowercase. If you consume a result set from this command with the pipe operator or the RESULT_SCAN function, use double-quoted identifiers for the column names in the query to ensure that they match the column names in the output that was scanned. For example, if the name of an output column is type, then specify "type" for the identifier.

示例¶

创建示例任务：

CREATE TASK mytask ( ... );

Copy

Show information about the task:

DESC TASK mytask;

Copy

For output examples, see SHOW_TASKS.