On-Demand Recordings from PrestoCon’s, Webinars, Meetups, and more
DataCTRL is a data management platform for ingesting large quantities of disparate data sets. We’ve written a connector for Presto which allows our users to leverage the data they’ve ingested using SQL. Integrating Presto with our platform has given our customers a quick and effective way to query their data while also building additional data products.
Prism is a gateway service for all Presto queries at Uber. It addresses Uber specific needs in four main areas – resource management, query gating, monitoring, and security. It is responsible for proxying over three million weekly queries from 6000+ weekly active users across all of Uber. Presto has variable execution times due to high multi-tenancy at Uber. Prism helps in overcoming those challenges using features like query routing, load balancing, query gating, session parameter checks, failover clusters which helps in maintaining a 99.9% availability and reliability SLA for Presto at Uber. Functionality – Query Execution: 1. Async execution API returns data stream 2. Async execution API returns File Descriptor – Routing – Prism can route queries to different clusters based on client sources. Other functionalities: Load Balancing, Query Gating, Failover, Session Properties, Security