Hi Team, for our use cases, we were trying out Apache Pinot. Since the use cases involved nested queries we thought of integrating it with some connector like Presto. As per Pinot doc, looks like the recommended connector is PrestoDB. Can anyone confirm if PrestoSQL (Trino) is recommended or not? P.S: We are reaching out to other communities (Trino) also to check their view.

Pinot works with both presto and trino.. we recommend trying out both and pick one that works best for you

@User works on the Trino-Pinot connector and uses this in production. He will be able to help here.

@User lets add it in ourselves! 😄 https://github.com/pinot-contrib/pinot-docs

That ^^ works too 🙂.

fair enough 🙂

Integrations

would be the right place to add. I see superset already there: https://docs.pinot.apache.org/integrations/superset

Hi All, Thanks for your input. We were facing issues with prestosql350 and Pinot 0.8 where queries were failing for consuming segments. We'll collect the required details and share them in #C011C9JHN7R room soon.

This is known, I am working on adding pinot-0.8.0 support to trino and locally this is working, I will be pushing the pr soon, will keep you updated.