INSIDE CLICKHOUSE FULL-TEXT SEARCH: FAST, NATIVE, AND COLUMNAR

Summary from the TLDR newsletter

ClickHouse completely rebuilt its full-text search to be faster, leaner, and fully native to the columnar database design. This article explains the new design, which enables high-performance search without having to leave the database. The new native text index makes search in ClickHouse fast, precise, and fully integrated. It allows users to run complex searches with the same efficiency as analytical queries.