From the course: Analyzing Big Data with Hive
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Finding similar values with LIKE - Hive Tutorial
From the course: Analyzing Big Data with Hive
Finding similar values with LIKE
- [Instructor] Now we're going to take a look at how to find similar values to what you're interested in using the LIKE Clause. The LIKE Clause is really just another way to filter your results, but now with a wildcard type syntax. For example if you wanted to find all customers with the word 'technology' in their name, you could use the LIKE operator on their name to identify them. We're going to start by building a SELECT statement using the complex data structures that we have. And then we'll filter down using the LIKE condition. So here in my Cloud area environment I'm going to open '5-3.sql'. And we'll copy this, go over to our Hive Editor, and scroll up to the top and take a look. First thing I want to do is just give me a list of all of the items that are on our order. So, from our customer's table, which if you recall from a previous clip we took a look at this, has a field called 'orders', and in there it has the items that are actually placed on the order. So what we can do…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.