Vector databases like Pinecone, Weaviate, and Milvus exist for one job: store embeddings and find the nearest ones to a query vector, fast. ClickHouse wasn't built for that. It was built for analytics - scanning huge tables of structured data quickly.
Source: [Dev.to](https://dev.to/mohhddhassan/can-clickhouse-replace-a-vector-database-4h45)