Learn about the syntax of a SELECT statement in Presto.
- [Instructor] Now we're going to get in…and start seeing what it takes…to retrieve data using Presto.…And if you're familiar with ANSI SQL,…this should be pretty straightforward to you,…but if you're not, this would be a good primer…for how to use ANSI SQL to get data out of a database.…So we've already seen several examples here,…but let's just refresh on the data…we loaded into our MySQL database earlier.…So first let me log into my Presto cluster,…typing Presto dash dash server then localhost colon 8080.…
And here I'm going to say show tables from MySQL dot test.…And you can see we have a customer…and US grad rates table that we created earlier.…First I want to just take a sample…from the customer table.…So select star from MySQL dot test dot customer.…So because I'm not logged into a specific schema…and catalog, I need to fully qualify…where the data lives, and I'll limit that…to 10 rows so we don't get bombarded here.…All right, so there's a sample of our data.…
You can take a look at that.…Now, I want to do something where I create an aggregate,…
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
Cassandra Data Modeling Essential Trainingwith Dan Sullivan1h 38m Intermediate
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.