Cookie Notice

This site uses cookies for performance, analytics, personalization and advertising purposes.

For more information about how we use cookies please see our Cookie Policy.

Manage Consent Preferences

Essential/Strictly Necessary Cookies

Required

These cookies are essential in order to enable you to move around the website and use its features, such as accessing secure areas of the website.

Analytical/ Performance Cookies

These are analytics cookies that allow us to collect information about how visitors use a website, for instance which pages visitors go to most often, and if they get error messages from web pages. This helps us to improve the way the website works and allows us to test different ideas on the site.

Functional/ Preference Cookies

These cookies allow our website to properly function and in particular will allow you to use its more personal features.

Targeting/ Advertising Cookies

These cookies are used by third parties to build a profile of your interests and show you relevant adverts on other sites. You should check the relevant third party website for more information and how to opt out, as described below.

Video

The best of both worlds: Achieving query latency and flexibility with Apache Pinot and Trino – Datanova 2023

Apache Pinot is an open-source, distributed OLAP datastore built to provide real-time analytics at ultra low-latency and extremely high throughput, typically needed for user facing workloads. Trino is a distributed, ANSI compliant SQL query engine that can process complex interactive queries over various data sources. By combining the power of Pinot and Trino, we unlock the ability to do complex ad-hoc analysis on real-time data as well as federate queries across Pinot and other data sources. Furthermore, by intelligently pushing down predicates and aggregation functions to Pinot, we can accelerate overall query performance. Listen to Chinmay Soman, founding engineer at Startree, discuss Apache Pinot and the architectural contexts in which combining both technologies together provides speed and scalability without sacrificing flexibility.