Learn about the different deployment options.
- [Instructor] There are three main deployment scenarios…for Presto I'll mention here…and the first one, of course, is just deploying it…on premise alongside your Hadoop cluster preferably…and this is the most straightforward way to do it.…With that you don't need huge machines…because you'll probably want…to distribute the queries quite a bit…so you can get away with smaller machines…and more of them in your data center…and this is really no major difference…than how you would stand up another cluster…of any other type of system.…Now if you're using Ambari from Hortonworks…they have a built in installer on that platform…and you can use that to get Presto up and running…on your Hadoop cluster.…
And lastly, if you want you can install Presto…in the AWS environment, the Amazon web services.…It works with elastic map reduce…as well as you could use the EC2 instances.…The medium sized ones should do fine for you…and you can stand that up and just make sure…that the connections are everything…so that wherever Presto is running,…
Data science expert Ben Sullins helps you get up to speed with Presto, and leverage it to accomplish a wide-range of data science and analytics tasks. He uses different interfaces with Presto—such as R and Tableau—and digs into the expressive SQL language that Presto offers for your analysis. At the end of this course, you'll know the key concepts of Presto and how to use them to take full advantage of your modern big data system.
- What does Presto do?
- Running Presto
- Connecting from Tableau and R
- Connecting to Hive, MySQL, and the local system
- Retrieving data
- Combining data sources
- Basic SQL functions
- Advanced SQL functions
- Migrating from Hive
Skill Level Intermediate
SQL: Data Reporting and Analysiswith Emma Saunders2h 16m Intermediate
Advanced SQL for Data Scientistswith Dan Sullivan1h 24m Advanced
1. Introducing Presto
2. Running Presto
4. SQL Syntax
5. Basic SQL functions
6. Advanced SQL Functions
7. Migrating from Hive
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.