> It seemed (and still seems) like a project that lives and dies with one developer

One major contributor (who may be project lead at Yandex?) and a lot of active contributors: https://github.com/yandex/ClickHouse/graphs/contributors