At the end of this video the student will know how to use the LIKE condition to filter results.
- [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 then is run this query…and take a look at everything that's in our results set,…
This course shows how to use Hive to process data. Instructor Ben Sullins starts by showing you how to structure and optimize your data. Next, he explains how to get Hue, the Hadoop user interface, to leverage HiveQL when analyzing data. Using the newly configured option, he then demonstrates how to load data, create aggregate tables for fast query access, and run advanced analytics. He also takes you through managing tables and putting functions to use. This course is designed to help you find new ways to work with datasets so you can answer the tough data science questions that come your way.
- Defining data structures in Hive
- Selecting data
- Joining tables
- Manipulating data
- Filtering results
- Aggregating data
- Using built-in aggregate functions
- Mastering built-in table-generating functions
- Using CUBE and ROLLUP
- Using clauses: WHERE and HAVING
- Using LIKE, JOIN, and SEMI JOIN
- Using functions: String, math, date, and conditional