Well . the major difference will be depending on the use case . For an example if you want to just index the data and query that data , Elastic can do it on scale . But the difference comes when you have to upsert those record in scale and get the response in terms of aggregation of those result sets . Pinot will do it pretty faster for you in comparison to elastic . Even when both are eventually consistent , pinot will be way ahead in the game just because instead of elastic , pinot can do the upsert in memory in the real time table and get you aggregated results .