3 ms·
Great demo! I'm curios why the following query doesn't finish in tens of seconds: select sum(passenger_count) from trips where passenger_count=1 The same
by valyala 6y ago
Great demo!
I'm curios why the following query doesn't finish in tens of seconds:
select sum(passenger_count) from trips where passenger_count=1
The same query is executed in a hundred of milliseconds on ClickHouse running on the same hardware (~20 vCPUs).
- bluestreak 6y agothe use of where clause right now turns off vectorization completely is falls back on simple single threaded execution. This is the reason why the query is slow right now. We are going to vectorize 'where' really soon.