We have been using ClickHouse in production for some months already and we find it a real game changer.
We're running queries over 3B rows for business intelligence purposes.
As a side project, a group of friends and I are working on a simple web analytics project powered by ClickHouse (what it's been originally build for).
If anyone wants to contribute, just let me know.