Hi Team, I had a general question. 1. Can we do joins in the Pinot? 2. If not then what is a workaround (apart from Dim tables)

Joins are supported in Pinot via the Multi-Stage Engine (https://docs.pinot.apache.org/developers/advanced/v2-multi-stage-query-engine).

Thanks! This should help a lot.