I've actually been looking for a comprehensive and detailed comparison of Clickhouse vs Pinot, so this is timely for me. I like that this article has some easy to digest lists of what is supported in each implementation, but that's fairly high-level. The deeper dives into features and specific use cases was much more helpful.