search

ClickHouse / ClickBench

ClickBench: a Benchmark For Analytical Databases
https://benchmark.clickhouse.com/
Other
676 stars 154 forks source link

Add Quickwit support #95

Open zamazan4ik opened 1 year ago

zamazan4ik commented 1 year ago

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".

fulmicoton commented 1 year ago

@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?

zamazan4ik commented 1 year ago

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.

fulmicoton commented 1 year ago

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.

alexey-milovidov commented 1 year ago

It's ok to add a DBMS without SQL support. For example, see MongoDB: https://github.com/ClickHouse/ClickBench/blob/main/mongodb/queries.js

alexey-milovidov commented 1 year ago

Looking forward to seeing Quickwit added!