Learn how to set up a connection to a the local system from Presto.
- [Instructor] Now let's take a look at the system catalog…which has a lot of information about your Presto cluster.…So to do that, we'll just log into Presto here.…And if you recall, we have a function here…called show catalogs.…That'll show me everything that Presto is aware of,…all the current catalogs that it can connect to.…We've already looked at Hive and MySQL.…Now we take a look at the system.…From here if I want to take a look…at what's inside of the system…I can say show schemas from system.…You can see that there are four different schemas in here…from four different data bases.…
Let's first take a look at the metadata schema.…So to see the tables in there I can say…show tables from system.metadata.…I can see I've got three different tables.…If I wanted to take a look at say catalogs, I can say…select star from system.metadata.catalogs.…And like that you can see all the catalogs…that are known to Presto.…So this system database has a lot of that information there.…
And if you recall when we looked at the Presto WebUI…
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?
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.