Loading
Frozen indices
By default, Elasticsearch SQL doesn't search frozen indices. To search frozen indices, use one of the following features:
- dedicated configuration parameter
- Set to
truepropertiesindex_include_frozenin theSQL search API orindex.include.frozenin the drivers to include frozen indices. - dedicated keyword
- Explicitly perform the inclusion through the dedicated
FROZENkeyword in theFROMclause orINCLUDE FROZENin theSHOWcommands:
SHOW TABLES INCLUDE FROZEN; catalog | name | type | kind---------------+---------------+----------+---------------javaRestTest |archive |TABLE |FROZEN INDEXjavaRestTest |emp |TABLE |INDEXjavaRestTest |employees |VIEW |ALIASjavaRestTest |library |TABLE |INDEXSELECT * FROM FROZEN archive LIMIT 1; author | name | page_count | release_date-----------------+--------------------+---------------+--------------------James S.A. Corey |Leviathan Wakes |561 |2011-06-02T00:00:00ZUnless 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.