Pinot
Apache Pinot - A realtime distributed OLAP datastore
...Near Realtime ingestion with Apache Kafka, Apache Pulsar, Kinesissupports JSON, Avro, ProtoBuf, Thrift formats. Apache Pinot supports dimension lookup joins currently. Full SQL join support in Apache Pinot is coming soon. In the interim, full SQL joins can be performed by querying Pinot via the Trino or PrestoDB connector. Apache Pinot provides SQL interface for querying interactively, as well as programmatically via rest-api.