我的书签
添加书签
移除书签This version of the OpenSearch documentation 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:
Rule 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 | 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 |
当前内容版权归 OpenSearch 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 OpenSearch .
