Link Search Menu Expand Document Documentation Menu

You're viewing version 2.17 of the OpenSearch documentation. This version is no longer maintained. For the latest version, see the current documentation. For information about OpenSearch version maintenance, see Release Schedule and Maintenance Policy.

Metadata queries

To see basic metadata about your indexes, use the SHOW and DESCRIBE commands.

Syntax

Rule showStatement:

showStatement

Rule showFilter:

showFilter

Example 1: See metadata for indexes

To see metadata for indexes that match a specific pattern, use the SHOW command. Use the wildcard % to match all indexes:

SHOW TABLES LIKE %
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS TYPE_CAT TYPE_SCHEM TYPE_NAME SELF_REFERENCING_COL_NAME REF_GENERATION
docker-cluster null accounts BASE TABLE null null null null null null
docker-cluster null employees_nested BASE TABLE null null null null null null

Example 2: See metadata for a specific index

To see metadata for an index name with a prefix of acc:

SHOW TABLES LIKE acc%
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS TYPE_CAT TYPE_SCHEM TYPE_NAME SELF_REFERENCING_COL_NAME REF_GENERATION
docker-cluster null accounts BASE TABLE null null null null null null

Example 3: See metadata for fields

To see metadata for field names that match a specific pattern, use the DESCRIBE command:

DESCRIBE TABLES LIKE accounts
TABLE_CAT TABLE_SCHEM TABLE_NAME COLUMN_NAME DATA_TYPE TYPE_NAME COLUMN_SIZE BUFFER_LENGTH DECIMAL_DIGITS NUM_PREC_RADIX NULLABLE REMARKS COLUMN_DEF SQL_DATA_TYPE SQL_DATETIME_SUB CHAR_OCTET_LENGTH ORDINAL_POSITION IS_NULLABLE SCOPE_CATALOG SCOPE_SCHEMA SCOPE_TABLE SOURCE_DATA_TYPE IS_AUTOINCREMENT IS_GENERATEDCOLUMN
docker-cluster null accounts account_number null long null null null 10 2 null null null null null 1   null null null null NO  
docker-cluster null accounts firstname null text null null null 10 2 null null null null null 2   null null null null NO  
docker-cluster null accounts address null text null null null 10 2 null null null null null 3   null null null null NO  
docker-cluster null accounts balance null long null null null 10 2 null null null null null 4   null null null null NO  
docker-cluster null accounts gender null text null null null 10 2 null null null null null 5   null null null null NO  
docker-cluster null accounts city null text null null null 10 2 null null null null null 6   null null null null NO  
docker-cluster null accounts employer null text null null null 10 2 null null null null null 7   null null null null NO  
docker-cluster null accounts state null text null null null 10 2 null null null null null 8   null null null null NO  
docker-cluster null accounts age null long null null null 10 2 null null null null null 9   null null null null NO  
docker-cluster null accounts email null text null null null 10 2 null null null null null 10   null null null null NO  
docker-cluster null accounts lastname null text null null null 10 2 null null null null null 11   null null null null NO  
350 characters left

Have a question? .

Want to contribute? or .