system.stemmers

System table which shows all available 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    │
 │ [...]      │
 └────────────┘