Hacker News new | ask | show | jobs
by snikolaev 1426 days ago
It's a very good question. The answer is that when people do data analytics they often also need full-text search, otherwise it may just be too slow to scan through all your terabytes of strings using LIKE or REGEXP. You need some indexes to make it faster. Indexes for strings is what's partly full-text search is.

That's why Clickhouse can be integrated with Quickwit, for example.

Manticore aims to be a good full-text search engine + can process large data volume that doesn't fit into RAM with help of the columnar storage.