IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
SHOW COLUMNS
editSHOW COLUMNS
editThis functionality is in technical preview and may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview are not subject to the support SLA of official GA features.
Synopsis.
See index patterns for more information about patterns.
DescriptionList the columns in table and their data type (and other attributes).
SHOW COLUMNS IN emp; column | type | mapping --------------------+---------------+--------------- birth_date |TIMESTAMP |DATE dep |STRUCT |NESTED dep.dep_id |VARCHAR |KEYWORD dep.dep_name |VARCHAR |TEXT dep.dep_name.keyword|VARCHAR |KEYWORD dep.from_date |TIMESTAMP |DATE dep.to_date |TIMESTAMP |DATE emp_no |INTEGER |INTEGER first_name |VARCHAR |TEXT first_name.keyword |VARCHAR |KEYWORD gender |VARCHAR |KEYWORD hire_date |TIMESTAMP |DATE languages |TINYINT |BYTE last_name |VARCHAR |TEXT last_name.keyword |VARCHAR |KEYWORD salary |INTEGER |INTEGER