On-Demand Recordings from PrestoCon’s, Webinars, Meetups, and more
Leveraging the benefits of PrestoDB with 3rd-party BI, reporting, ETL, and custom applications can present unique challenges. The CData Connectivity Solutions allow you to connect, integrate, and automate your PrestoDB data in the tools and applications you already use. In this video, you’ll learn about the different connectivity solutions CData offers and see how to connect to PrestoDB through CData’s technology.
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