v.25.10Experimental Feature

Functions searchAll and searchAny now work

Functions searchAll and searchAny now work on top of columns without text columns. In those cases, they use the default tokenizer. #87722 (Jimmy Aguilar Mena).
The functions searchAll and searchAny now support operating on columns that are not text columns by using the default tokenizer.

Why it matters

Previously, searchAll and searchAny functions were limited to text columns, restricting their use cases. This feature expands their applicability to non-text columns by employing a default tokenizer, enabling broader and more flexible full-text search capabilities in ClickHouse.

How to use it

Use searchAll and searchAny functions as usual on any column type. When the column is not a text column, the functions will automatically use the default tokenizer without requiring additional configuration.