Saurabh Mahawar, Author at PrestoDB

Presto-Lance Connector: Querying Vector Embeddings with Distributed SQL
By Saurabh Mahawar & Jianjian Xie June 21, 2026June 22, 2026
As artificial intelligence and machine learning (ML) models become integral to modern software, organizations are storing billions of high-dimensional vectors (embeddings) alongside traditional metadata. Analyzing this multi-modal data at scale requires a bridge between high-performance vector databases and distributed SQL query engines. Recently, the Presto open-source community introduced a native Lance Connector (added in release…
Read More Presto-Lance Connector: Querying Vector Embeddings with Distributed SQL
Bridging Java and Native Execution: Presto Connector Federation with Apache Arrow Flight
By Bryan Cutler, Pratik Joseph Dabre & Saurabh Mahawar June 15, 2026June 15, 2026
Introduction: The Federation Challenge in Modern Query Engines The evolution of distributed query engines has created a fundamental architectural tension. Over the past decade, the Presto ecosystem has developed an extensive collection of production-grade Java-based connectors, providing federated access to hundreds of heterogeneous data sources. Concurrently, native C++ execution engines built on frameworks like Velox…
Read More Bridging Java and Native Execution: Presto Connector Federation with Apache Arrow Flight
Presto Benchmarking Tutorial – TPC-H & TPC-DS on Iceberg with Google Cloud Storage (GCS)
By Saurabh Mahawar May 3, 2026May 3, 2026
TL;DR: What You Will Build In this comprehensive guide, you will deploy a Presto benchmarking setup using Docker Compose. We will construct a cloud-native Data Lakehouse by mapping raw data into Apache Iceberg tables stored on Google Cloud Storage (GCS). Finally, we will execute the industry-standard TPC-H and TPC-DS benchmark suites using PBench, and visualize our query latencies in real-time using a persistent MySQL and Grafana observability stack. Whether you are stress-testing…
Read More Presto Benchmarking Tutorial – TPC-H & TPC-DS on Iceberg with Google Cloud Storage (GCS)
Deploy Presto on Kubernetes using Helm: Query S3 Data with Hive Metastore
By Saurabh Mahawar February 27, 2026February 27, 2026
Deploying Presto on Kubernetes transforms this powerful engine into a cloud-native, resilient service that automatically handles failures, scales seamlessly, and optimizes resource utilization. When combined with Helm charts, the deployment becomes standardized, version-controlled, and easily reproducible across environments. This comprehensive guide will walk you through deploying a production-capable baseline Presto cluster on Kubernetes using the official Presto Helm…
Read More Deploy Presto on Kubernetes using Helm: Query S3 Data with Hive Metastore
TPC-H vs TPC-DS : Benchmarking Modern Distributed SQL Engines like Presto
By Saurabh Mahawar January 30, 2026May 11, 2026
In the world of big data, performance is the ultimate currency. But when you are processing petabytes of data across a distributed cluster, speed isn’t just about a stopwatch, it’s a high-stakes engineering challenge. Whether you are evaluating Presto, Spark or any other engine, you need an objective yardstick. Performance in a distributed SQL engine…
Read More TPC-H vs TPC-DS : Benchmarking Modern Distributed SQL Engines like Presto
From Zero to Contributor: A Complete Guide to Contributing to Presto Open Source
By Saurabh Mahawar January 9, 2026January 9, 2026
PrestoDB is a powerful distributed SQL query engine used widely for large-scale data analytics. Contributing to Presto is an excellent way to gain hands-on experience with distributed systems, Java, SQL engines, and large open-source codebases. This step-by-step tutorial is designed specifically for beginners and first-time contributors who want to build Presto from source, run the…
Read More From Zero to Contributor: A Complete Guide to Contributing to Presto Open Source
Understanding Presto UI: A Deep Dive into the Web Interface Architecture
By Saurabh Mahawar December 1, 2025December 1, 2025
Presto UI is a modern, React-based web interface that provides real-time monitoring, query management, and cluster administration capabilities for the Presto distributed SQL query engine. Whether you’re a database administrator, data engineer, or developer, Presto UI offers intuitive tools to visualize query execution, monitor cluster health, and interact with the Presto coordinator. Key Benefits of…
Read More Understanding Presto UI: A Deep Dive into the Web Interface Architecture
Seamless Integration: Connecting PrestoDB to SingleStore for High-Performance Analytics
By Saurabh Mahawar September 11, 2025November 19, 2025
In today’s data-driven landscape, organization’s are constantly seeking ways to analyze massive datasets quickly and efficiently. PrestoDB, a powerful open-source SQL query engine, and SingleStore, a distributed SQL database, are two technologies that, when combined, offer unparalleled capabilities for high-performance data querying and distributed analytics. This guide provides a hands-on, step-by-step tutorial on how to…
Read More Seamless Integration: Connecting PrestoDB to SingleStore for High-Performance Analytics
Prestissimo Extension for AI Training Data Normalization at Meta: A Deep Dive for Developers (Lightning Talk)
By Saurabh Mahawar August 23, 2025August 23, 2025
At PrestoCon Day 2025, Meta’s Presto team recently unveiled the Prestissimo extension, a powerful enhancement designed to optimize AI training data normalization. This article explores the technical underpinnings and developer-centric features of this extension, providing a comprehensive understanding of how it supports large-scale AI workloads at Meta. Understanding AI Training Data Storage at Meta At…
Read More Prestissimo Extension for AI Training Data Normalization at Meta: A Deep Dive for Developers (Lightning Talk)
Presto C++ Unleashed: Dynamically Load Unfenced UDFs, End Rebuilds, and Boost Performance
By Saurabh Mahawar August 22, 2025August 22, 2025
Dynamic loading in Presto C++ is revolutionizing how developers build and deploy user-defined functions (UDFs). At PrestoCon Day 2025 , Soumya Duriseti explained how Presto C++ now supports dynamic loading of unfenced UDFs, eliminating the need for time-consuming static builds and making it easier than ever to add custom logic without rebuilding the entire binary….
Read More Presto C++ Unleashed: Dynamically Load Unfenced UDFs, End Rebuilds, and Boost Performance
Building Connectors in Presto C++: Deep Dive into the TPCDS Connector (Lightning Talk)
By Saurabh Mahawar, Pramod Satya & Pratik Joseph Dabre August 20, 2025August 20, 2025
At PrestoCon Day 2025, engineers from IBM presented a deep dive into how connectors in Presto C++ extend the engine’s modular capabilities, focusing on the newly implemented TPCDS benchmark connector. Connectors are central to Presto’s architecture, enabling the query engine to communicate seamlessly with external systems such as databases, file formats, or benchmark data generators….
Read More Building Connectors in Presto C++: Deep Dive into the TPCDS Connector (Lightning Talk)
Presto’s Intelligent Future: Leveraging RAG and LLM’s for Smarter Query Execution
By Saurabh Mahawar August 12, 2025August 12, 2025
At PrestoCon Day 2025, Satej Sahu (Principal Data Engineer at Zalando SE) introduced the Self-Healing Query Connector for Presto, an AI-powered upgrade designed to make query troubleshooting faster, smarter, and more reliable. By combining Large Language Models with live query data, including logs, explain plans, and schema details it delivers accurate, context-aware solutions that improve…
Read More Presto’s Intelligent Future: Leveraging RAG and LLM’s for Smarter Query Execution
Revolutionizing Presto C++: Unleashing Native Power with the Sidecar
By Saurabh Mahawar, Pramod Satya & Pratik Joseph Dabre August 10, 2025August 11, 2025
At PrestoCon Day 2025, we unveiled the Presto Sidecar, a powerful enhancement for Presto C++ (Velox) clusters that transforms how coordinators interact with native workers. This innovation removes long-standing blind spots in query planning by giving the coordinator real-time visibility into native worker capabilities – such as supported functions, data types, session properties, and plan…
Read More Revolutionizing Presto C++: Unleashing Native Power with the Sidecar
Unlocking Petabyte-Scale Performance: Uber’s Journey with Presto for Distributed Cache using Alluxio
By Saurabh Mahawar August 8, 2025August 28, 2025
At PrestoCon Day 2025, Uber presented their innovative solution for optimizing petabyte-scale data analytics by deploying a distributed cache using Alluxio for Presto. Their journey was driven by significant challenges during a massive cloud migration, including read slowness and overwhelming HDFS clusters on-premises, and later high GCS egress costs and file access charges in the…
Read More Unlocking Petabyte-Scale Performance: Uber’s Journey with Presto for Distributed Cache using Alluxio
Unleashing Interactivity: Inside Meta’s Presto-Powered Data Warehouse Innovation
By Saurabh Mahawar August 7, 2025August 7, 2025
At this year’s PrestoCon Day, Meta had an awesome session to share the latest on what they’re doing with Presto. As you probably know, Meta has one of the largest data Lakehouse’s in the world and Presto is a critical piece of that data platform. It plays a critical role in serving vast and diverse…
Read More Unleashing Interactivity: Inside Meta’s Presto-Powered Data Warehouse Innovation
Setting Up Presto with Apache Superset: Hands-On Guide
By Saurabh Mahawar August 7, 2025August 7, 2025
PrestoDB, an open-source distributed SQL query engine, allows you to query data from multiple disparate sources. When combined with Apache Superset, an open-source data visualization and exploration platform, it forms a powerful and flexible analytics solution. This guide provides a step-by-step approach to deploying these components within a Dockerized environment, simplifying setup and management. Pre-Requisites:…
Read More Setting Up Presto with Apache Superset: Hands-On Guide
Build Your Open Data Lakehouse: A Step-by-Step ETL Guide with MySQL, OLake, and PrestoDB
By Saurabh Mahawar July 29, 2025August 19, 2025
This tutorial provides a comprehensive guide to building an Open Data Lakehouse from scratch, a modern and flexible data architecture solution. Open Data Lakehouses offer a powerful and scalable method for storing, managing, and querying both structured and semi-structured data, leveraging a suite of robust open-source tools for enhanced control and flexibility. Pre-Requisites: Before commencing…
Read More Build Your Open Data Lakehouse: A Step-by-Step ETL Guide with MySQL, OLake, and PrestoDB
Presto Installation : A Step by Step Guide to Run SQL Queries
By Saurabh Mahawar July 15, 2025February 12, 2026
Install and run PrestoDB (0.296+) on your local machine in under 10 minutes. Follow this hands-on tutorial to deploy a high-performance SQL query engine for your Data Lakehouse architecture. Prerequisites Before getting started, ensure that the following are installed: Download and Extract Run these commands in your terminal to download the latest server package. Configure…
Read More Presto Installation : A Step by Step Guide to Run SQL Queries