Presto 101t Documentation

8.5. DESCRIBE

8.5. DESCRIBE

Synopsis

DESCRIBE table_name

Description

DESCRIBE is an alias for SHOW COLUMNS.

Examples

presto:default> describe airline_origin_destination;
     Column      |  Type   | Null | Partition Key
-----------------+---------+------+---------------
 itinid          | varchar | true | false
 mktid           | varchar | true | false
 seqnum          | varchar | true | false
 coupons         | varchar | true | false
 year            | varchar | true | false
 quarter         | varchar | true | false
 origin          | varchar | true | false
 originaptind    | varchar | true | false
 origincitynum   | varchar | true | false
(9 rows)