DESCRIBE QUERY
适用于: Databricks SQL Databricks Runtime
返回查询输出的元数据。
语法
{ DESC | DESCRIBE } [ QUERY ] input_statement
参数
QUERY
此子句是可选的,并可以省略。
-
要描述的查询。
示例
-- Create table `person`
> CREATE TABLE person (name STRING , age INT COMMENT 'Age column', address STRING);
-- Returns column metadata information for a simple select query
> DESCRIBE QUERY SELECT age, sum(age) FROM person GROUP BY age;
col_name data_type comment
-------- --------- ----------
age int Age column
sum(age) bigint null
-- Returns column metadata information for common table expression (`CTE`).
> DESCRIBE QUERY WITH all_names_cte
AS (SELECT name FROM person) SELECT * FROM all_names_cte;
col_name data_type comment
-------- --------- -------
name string null
-- Returns column metadata information for an inline table.
> DESCRIBE QUERY VALUES(100, 'John', 10000.20D) AS employee(id, name, salary);
col_name data_type comment
-------- --------- -------
id int null
name string null
salary double null
-- Returns column metadata information for `TABLE` statement.
> DESCRIBE QUERY TABLE person;
col_name data_type comment
-------- --------- ----------
name string null
age int Agecolumn
address string null