Description
Presto was originally designed to run interactive queries against data warehouses, but now it has evolved into a unified SQL engine on top of open data lake analytics for both interactive and batch workloads. However, Presto doesn't scale to very large and complex batch pipelines. Presto Unlimited was designed to address such scalability challenges but it didn’t fully solve fault tolerance, isolation, and resource management. Spark is the tool of choice across the industry for running large scale complex batch ETL pipelines. This motivated the development of Presto On Spark. Presto on Spark runs Presto as a library that is submitted with spark-submit to a Spark cluster. It leverages Spark for scaling shuffle, worker execution, and resource management. It thereby eliminates any query conversion between interactive and batch use cases. This solution helps enable a performant and scalable platform with seamless end-to-end experience to explore and process data. Many analysts at Intuit use Presto to explore data in the Data Lake/S3 and use Spark for batch processing. These analysts would earlier spend several hours converting these exploration SQLs written for Presto to Spark SQL to…
Description from YouTube. Full content on the video page.
Topics
More from Databricks
NewsDatabricks for Good x MapAid: Creating a Searchable Database for Groundwater Discovery
MapAid is using Databricks to build an AI groundwater mapping system called Well Mapper that processes water documents to identify accurate well-drilling locations in Ethiopia, improving on the current 30% success rate. The system analyzes 400 well logs in half a second instead of four weeks, with potential to double Ethiopia's food supply through improved irrigation.
NewsHow Databricks Genie Automates Data Workflows with Genie Ontology and Scheduled Tasks
Databricks Genie enables ontology by default for business context and adds document/PDF uploads, direct Unity Catalog queries, and team collaboration features in chat. Scheduled tasks automate recurring workflows with embedded visualizations and PDF outputs accessible across web, desktop, and mobile platforms.
NewsGenie One Beginner's Guide: Explore Data & Automate Tasks
Genie One helps subject matter experts avoid repetitive questions by using business ontology to understand your data and run real-time queries that generate instant answers and shareable reports. The tool can also automate monitoring with conditional alerts that only notify you when specific business thresholds are met.
TutorialsHow to Schedule Automated Meeting Prep in Genie One
Genie One allows users to connect multiple data sources like Databricks tables and Google Calendar, then create analyses through natural language prompts to prepare for customer meetings. The platform can schedule these analyses to run automatically on a recurring basis and deliver results via email or mobile app.
TutorialsHow to Build Custom Skills in Genie One in Minutes
Genie 1 can populate business report templates by analyzing their format and running SQL queries against organizational data. Users can save these report workflows as reusable skills that execute with a single slash command, enabling automation of recurring reports.
TutorialsHow to Create & Share Polished Documents in Genie One
Genie One documents enable creation of polished reports with AI-generated narratives and interactive charts sourced from Databricks data. The feature supports real-time collaborative editing between users and Genie, sharing with team members for comments, and scheduling automated report generation.