Learn how to parse URL strings with built-in Presto functions.
- [Instructor] Another type of data that you may run into…and Presto has some good functions for you to work with…is URLs, and URLs have a specific format.…You may not totally be aware,…if you're not into web development,…and you haven't done that thing,…but you most likely will come across this data,…especially if you're working with web data.…So lets take a look here at how to work with URLs in Presto.…First, I'm going to log in to Presto,…and from here what I want to do is parse the URL,…and we'll check out all the functions we want to go here.…
So I'll start out with a with statement to create a table…that I can reference.…So with u as, I'm going to say select,…and I'm just going to paste in a link here.…So this is the link to search for me on Linkedin Learning,…and it has all the components of a URL…that we would typically want to parse,…so I'll just call that as url.…Now to work with that,…we have lots of different functions here.…So first we'll say select and we'll do url extract,…so this is how we parse out all the different parts.…
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.