This is a very comprehensive and objective comparison, I understand that Apache Pinot has a slightly newer architecture has some perf advantages however I felt that the authors did a good job comparing architectures and features. I will recommend this article to those who are considering building a modern user facing analytics application.
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.
I've spent plenty of time with TSDBs, but until recently have had no OLAP use case for my work. Now that I'm obligated, I'm reading and looking around for as much solid info as I can find. This is a good comparison that I'm finding useful. I appreciate that the authors give an honest assessment of their company's weaknesses and not just highlighting their strengths vs competitors.