The inverted text index implementation in ClickHouse has been completely redesigned to improve scalability for large datasets that exceed available RAM.
Why it matters
This feature addresses the limitations of the previous inverted text index which could not efficiently handle datasets larger than the system's RAM. By reworking the index from scratch, it now supports scalable text search operations on much larger datasets, enhancing performance and usability for big data use cases.How to use it
Users benefit from this reworked inverted text index transparently when creating and querying text indexes on large datasets. No additional configuration is required beyond using the standard text index features.