Most businesses end up with data in a myriad of places with varying levels of structure. This makes it difficult to gain insights from across departments, projects, or people. Presto is a distributed SQL engine that allows you to tie all of your information together without having to first aggregate it all into a data warehouse. Kamil Bajda-Pawlikowski co-founded Starburst Data to provide support and tooling for Presto, as well as contributing advanced features back to the project. In this episode he describes how Presto is architected, how you can use it for your analytics, and the work that he is doing at Starburst Data.
Do you want to try out some of the tools and applications that you heard about on the Data Engineering Podcast? Do you have some ETL jobs that need somewhere to run? Check out Linode at linode.com/dataengineeringpodcast or use the code dataengineering2019 and get a $20 credit (that’s 4 months free!) to try out their fast and reliable Linux virtual servers. They’ve got lightning fast networking and SSD servers with plenty of power and storage to run whatever you want to experiment on.
- Hello and welcome to the Data Engineering Podcast, the show about modern data management
- When you’re ready to build your next pipeline you’ll need somewhere to deploy it, so check out Linode. With private networking, shared block storage, node balancers, and a 40Gbit network, all controlled by a brand new API you’ve got everything you need to run a bullet-proof data platform. Go to dataengineeringpodcast.com/linode to get a $20 credit and launch a new server in under a minute.
- Go to dataengineeringpodcast.com to subscribe to the show, sign up for the newsletter, read the show notes, and get in touch.
- Your host is Tobias Macey and today I’m interviewing Kamil Bajda-Pawlikowski about Presto and his experiences with supporting it at Starburst Data
- How did you get involved in the area of data management?
- Can you start by explaining what Presto is?
- What are some of the common use cases and deployment patterns for Presto?
- How does Presto compare to Drill or Impala?
- What is it about Presto that led you to building a business around it?
- What are some of the most challenging aspects of running and scaling Presto?
- For someone who is using the Presto SQL interface, what are some of the considerations that they should keep in mind to avoid writing poorly performing queries?
- How does Presto represent data for translating between its SQL dialect and the API of the data stores that it interfaces with?
- What are some cases in which Presto is not the right solution?
- What types of support have you found to be the most commonly requested?
- What are some of the types of tooling or improvements that you have made to Presto in your distribution?
- What are some of the notable changes that your team has contributed upstream to Presto?
- From your perspective, what is the biggest gap in the tooling or technology for data management today?
- Starburst Data
- Cost Based Optimizer
- ANSI SQL
- Spill To Disk
- Geospatial Functions