Why does Pinot exist? It looks like a rip off of Apache Druid and Clickhouse. Does the world really need Pinot too...what are the differences? Or was this just done because LinkedIn and Uber engineers had nothing better to do?

you’re welcome to not use Pinot 🙂 There’s over a thousand different relational OLTP SQL databases, each with its own quirks, use cases, and vendors. Why is it so surprising to imagine even a few options in the real-time OLAP space? https://leventov.medium.com/comparison-of-the-open-source-olap-systems-for-big-data-clickhouse-druid-and-pinot-8e042a5ed1c7

pinot has lots of flexibility and great indexing techniques, just read comparisons between pinot and others realtime olap systems

Don't they all? Scanning the Pinot code, it especially looks like a fork of Druid, and CH seems a bit more of a lightweight OLAP db

We are using CH is production and currently running POC on Pinot as one of our use cases are not performing well on CH. Each of these system has some advantages and disadvantages.

For example, the biggest different thing is partitioning. Druid forces you to partition data by time, pinot does not. Dont look the code first. Just look the documentations and find limits. Each of them has similar concepts but actually there are very different i think

Having Mysql doesn’t mean that we should not have SqlLite as RBMS