ClickHouse
Add Quickwit support
Would be nice to see Quickwit comparison as well since at least ElasticSearch is supported here right now.
Pinging @fulmicoton - probably you could be interested in it at least from the perspective "where Quickwit performance could be improved compared to other engines".
@zamazan4ik Oh that would be awesome. Unfortunately Quickwit does not handle SQL at the moment. I eyeballed the SQL queries... Maybe we can perform the same computation in Quickwit 0.5 with the JSON DSL. Would that be ok or do we need to support SQL?
Maybe we can perform the same computation in Quickwit 0.5 with the JSON DSL. Would that be ok or do we need to support SQL?
I think it would be ok, since here authors mention the possibility to improve performance via rewriting queries into the native DSL.
I had a look at the bench. Maybe we cannot perform all of the queries yet, but it seems like the benchmark is pretty flexible and will run the queries we can run.
The set of queries is not really friendly to search engines, but it should still be very instructive for us.
It's ok to add a DBMS without SQL support. For example, see MongoDB: https://github.com/ClickHouse/ClickBench/blob/main/mongodb/queries.js
https://github.com/ClickHouse/JSONBench/pull/104 adds Quickwit to JSONBench. Perhaps we can add to ClickBench as well? @cometkim
