v.25.11Improvement

Support Array of String as

Support Array of String as an input to the hasAnyTokens or hasAllTokens functions. #89124 (Elmi Ahmadov).
Support for passing an array of strings as input to the hasAnyTokens and hasAllTokens functions in ClickHouse.

Why it matters

This feature allows users to efficiently check if any or all tokens from an array of strings exist within a given string, simplifying queries that require token matching with multiple candidates and enhancing flexibility when working with tokenized string data.

How to use it

Users can now provide an array of strings as an argument to the hasAnyTokens or hasAllTokens functions instead of a single string. For example:

SELECT hasAnyTokens('sample text', ['token1', 'token2', 'sample'])

This will check if any of the tokens in the array exist in the target string.