Apache Pinot

Hi all,
Im evaluating Pinot for realtime analytics for our feature on mobile app.
The total record is about 50-100K transactions/day. Is it good to adopt Pinot, Im afraid of too much engineering on it.

While we would love for you to use Pinot, the Data size (100k) is too small to need something like Pinot. An rdbms like postgres or MySQL should be a good start.

100k is per day or total? Also what is the total retention 

100K is per day, Total now is 30 million records.

May you advise when it would be good point to use Pinot?
Beside main topic `txn` , we also have other smaller size topics which might be used for joining with txn ones to show the aggregation report.

We plan to head up to 200K txns/day once users growth

30M rows is still small, but definitely better than 100k in terms of RoI for using Pinot 

Especially if you think it will grow soon

If you have real-time, and also want to expose analytics to end users, then you can definitely consider Pinot even for this scale 