原英文版地址: https://www.elastic.co/guide/en/elasticsearch/reference/7.7/sql-syntax-show-columns.html, 原文档版权归 www.elastic.co 所有
本地英文版地址: ../en/sql-syntax-show-columns.html
重要: 此版本不会发布额外的bug修复或文档更新。最新信息请参考 当前版本文档。
Elasticsearch Guide [7.7] » SQL access » SQL Language » SHOW COLUMNS
« SELECT SHOW FUNCTIONS »

SHOW COLUMNSedit

Synopsis:

SHOW COLUMNS [ FROM | IN ]?
    [table identifier | 
    [LIKE pattern] ]

single table identifier or double quoted es multi index

SQL LIKE pattern

See index patterns for more information about patterns.

Description: List the columns in table and their data type (and other attributes).

SHOW COLUMNS IN emp;

       column       |     type      |    mapping
--------------------+---------------+---------------
birth_date          |TIMESTAMP      |datetime
dep                 |STRUCT         |nested
dep.dep_id          |VARCHAR        |keyword
dep.dep_name        |VARCHAR        |text
dep.dep_name.keyword|VARCHAR        |keyword
dep.from_date       |TIMESTAMP      |datetime
dep.to_date         |TIMESTAMP      |datetime
emp_no              |INTEGER        |integer
first_name          |VARCHAR        |text
first_name.keyword  |VARCHAR        |keyword
gender              |VARCHAR        |keyword
hire_date           |TIMESTAMP      |datetime
languages           |TINYINT        |byte
last_name           |VARCHAR        |text
last_name.keyword   |VARCHAR        |keyword
salary              |INTEGER        |integer
« SELECT SHOW FUNCTIONS »