Browse the Presto web UI.
- [Instructor] For the administrators out there looking…to understand what's going on on your Presto cluster…or for analysts or scientists if you have an issue…with a query you can browser over to the Presto web UI…which is the IP of the machine on port 8080…in your web browser.…When you get there, you'll see some high level stats on top.…The number of running queries, the number of active workers,…rows per second, number of queued queries…so those that aren't been executed currently…but are going to be.…If there's any blocking going on with the blocked queries…and a few other stats here that just help you understand…the health of the cluster.…
Now in our environment here we're just looking…at one worker and it's a VM on our local machine…so not a whole lot of stats popping up…but this is where if you're an admin…maybe you want to put this up in the nock somewhere…and just view that so you can see what's going on…if you have a large Presto cluster or a lot of users…that depend on it.…When you go down to the query details here…
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.