Hi @User and everyone 👋, I am a data engineer at expediagroup and currently POC ing Pinot for one of our use case. Performance is very promising but we struggled a bit with setup, one of the reason was low kubernetes support in our environment. Another hurdle we encountered was lack of subquery/join support, guess we might have to use it in conjunction with presto for that. Still trialling.

Welcome to the community @User. Please feel free to ask questions in the channels, we are here to help.

Hey @User! I'm from the Trino (formerly PrestoSQL) project and we do a lot of overlapping work with Pinot to address the very issue you all are facing (subquery/join support)! In fact we had an episode on the Trino Community Broadcast a couple months back where we invited @User and @User to discuss Pinot and how well our tech pairs together. It has a getting started example you can run through for a proof of concept. We invite you to join the Trino Slack if you have any questions about how to connect Pinot and Trino.

thanks Brian, I will give it a go

Welcome welcome!! ❤️

Hi @User, welcome! Please let me know if you have any questions or issues with the trino pinot connector. I will help you set it up.