DoorDash: Supporting Multiple Pinot Use Cases at Scale

In this presentation, Will Gan (Software Engineer, DoorDash) focuses on two use cases at DoorDash: Mx Portal Ads Campaign Reporting and Risk Platform Dashboarding. DoorDash utilizes Pinot for real-time analytics and low query latency. For the Mx Portal use case, they use hybrid tables to track impressions, clicks, and orders. Challenges arose with data volume, but co-locating rows and separating REALTIME and OFFLINE servers improved performance. In the Risk Platform use case, dashboards were built using Superset on top of Pinot tables. Optimizing resource usage was achieved by onboarding to Tiered Storage, reducing server count.