IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.

« Index patterns Functions and Operators »

› › ›

Frozen Indices

edit

Frozen Indices

edit

By default, Elasticsearch SQL doesn’t search frozen indices. To search frozen indices, use one of the following features:

dedicated configuration parameter: Set to true properties index_include_frozen in the SQL search API or index.include.frozen in the drivers to include frozen indices.
dedicated keyword: Explicitly perform the inclusion through the dedicated FROZEN keyword in the FROM clause or INCLUDE FROZEN in the SHOW commands:

SHOW TABLES INCLUDE FROZEN;

     name      | type     |     kind
---------------+----------+---------------
archive        |TABLE     |FROZEN INDEX
emp            |TABLE     |INDEX
employees      |VIEW      |ALIAS
library        |TABLE     |INDEX

SELECT * FROM FROZEN archive LIMIT 1;

     author      |        name        |  page_count   |    release_date
-----------------+--------------------+---------------+--------------------
James S.A. Corey |Leviathan Wakes     |561            |2011-06-02T00:00:00Z

Unless enabled, frozen indices are completely ignored; it is as if they do not exist and as such, queries ran against them are likely to fail.

« Index patterns Functions and Operators »