There are other OLAP database out there that also provide real time (Clickhouse, Apache Druid, StarRocks). The negatives with Apache Pinot as I understand it is: slow performance (4x slower on ClickHouse Benchmark compared to StarRocks), no Cost Based Optimizer and cannot query Apache Iceberg or Apache Hudi or any of the open table formats on data lake.