A look through the below does highlight some of its differences with a standard sql database.

https://www.slideshare.net/Altinity/migration-to-clickhouse-...

Year on now, perhaps things have changed.