Hi, thank you!
we are evaluating pinot for
monday.com for a use-case in which we would need the ability to query (sort/filter) multiple dynamic tables that our clients are creating on any column of their choice (olap).
most tables are not so big, but potentially some tables would have hundreds of columns (and few million rows), so it's challenging to allow such querying on any column for a client-facing app.
moreover, the data is mutable. size is a total of few terabytes.
the good thing is that we at least don't need joins 🙂
Pinot looks like a very interesting project to address our use-case. would be glad to hear your thoughts if you agree!