Companies Using Presto Today
Platform24, the digital healthcare SaaS platform for healthcare providers, based in Sweden uses Presto as SQL engine for their Modern Data Platform to address the need of Open Source, Self hosted, Kubernetes friendly, Reliable, Scalable and Cost effective, etc.
Rippling, a popular HR and payroll platform, uses Presto to power their data platform and enable real-time querying at scale. Coupled with Apache Pinot, it can handle large amounts of data at significant scale. Specifically, they’ve focused on utilizing Presto for projection push down. For complex SQL queries that get translated into even more complex SQL statements, they can push down certain operations to save time. They’ve also implemented dynamic filtering push down, which pushes the filtering down into the connector and allows for the scan to be filtered as well. This results in a significant reduction in the amount of data being scanned and processed.
Securonix uses Ahana Cloud for Presto to enable extremely fast SQL queries on AWS S3 for ‘Threat Hunting’. “Before Presto we were using a Hadoop cluster, and the challenge was on scale…not only was it expensive but the scaling factors were not linear. The Presto engine was designed for scale, and it’s feature-built just for a query engine. Ahana Cloud made it easy for us to use Presto in the cloud.” – Derrick Harcey, Chief Architect at Securonix
HermesDB is the next generation of OLAP engine at Tencent with the architecture featuring separation of storage and calculation. HermesDB characterizes efficient indexing files in storage data, equipping with customized Presto as the core query engine. With the help of Presto connector, HermesDB could not only support full ANSI syntax but also ultilize Apache Lucene as underlying computer core.
Twilio uses Presto on AWS. Approximately 80% of Twilio’s data comes from product teams that use Kafka or MySQL databases. In addition to this, the company receives data from external sources such as Salesforce, Zendesk, and Marketo, as well as internal CSV files generated by accounting and finance teams. This data is loaded into the S3 data lake using config-driven Python and Spark-based loaders. With Presto, they can decouple the storage and compute layers and scale without affecting performance. In addition to data exploration and ad-hoc analysis by data analysts, Presto has also been used as a data source for real-time dashboards and machine learning models.
Uber uses Presto for the SQL Data Lakehouse where over 7K weekly active users run 500K queries/day on 59 PB HDFS bytes/day.
Zain Sudan is a mobile phone operator in Sudan (and was the first mobile phone operator in Sudan when it started in 1996!), and part of the Zain Group. Today, there are over 11M subscribers and a number of internal analysts to support in everyday business use cases.
Presto was deployed with seven worker nodes and two coordinators, providing a stable and high-performance environment. The majority of queries now execute within one second, demonstrating significant performance improvements.
16.5K GitHub Stars