ClickHouse documentation recommends using hasAnyTokens / hasAllTokens for full-text search against its text inverted index. We followed that guidance precisely and ran eight WHERE … LIMIT 100 queries against a 5 TB log table, comparing it with CtrlB on the same hardware.
We could not load this benchmark article body right now. Please try again in a moment.