system.stemmers

Description

Shows all available stemmers. These can be used in the function stem.

Availability

system.stemmers is present only in ClickHouse builds compiled with the libstemmer dependency (USE_LIBSTEMMER). On builds without it, the table does not exist and queries against it will fail with UNKNOWN_TABLE. You can check whether your build has it enabled with:

SELECT value FROM system.build_options WHERE name = 'USE_LIBSTEMMER';

Columns:

• name (String) — Identifier of the Snowball stemmer (language/algorithm)

Example

SELECT * FROM system.stemmers;

 ┌─name───────┐
 │ arabic     │
 │ armenian   │
 │ basque     │
 │ catalan    │
 │ danish     │
 │ dutch      │
 │ english    │
 │ [...]      │
 └────────────┘