Hi ! Just checked V2 query engine has support for joins. When is the team planning to launch it in stable mode ?

using trino as a query engine, it has full support for joins. “While Trino is not as fast as Pinot, it is able to handle a broader set of use cases like performing broad joins over open data formats in data lakes. This is what motivated work on the Trino Pinot connector. You can have the speed of Pinot, while having the flexibility of Trino.” - https://trino.io/episodes/13.html

Thanks @Thomas Steinholz, I will explore this.

V2 engine will be stable and ready by end of this year..