At the end of this video the student will know how to filter out individual results with the WHERE clause.
- [Instructor] Let's see now how to actually filter…our results using the where clause.…This is the clause that allows you to focus your results…to a specific context such as a particular region or year…or even a partition of the data that you're looking at.…We're going to start out by writing a simple select statement,…and then we're going to filter using equals and between,…two different ways of applying a filter condition.…Here in my Cloudera environment, I'll go take a look…at the scripts, and I'm going to open 5-1.sql.…
I'm going to copy this, and then go back to my Hue editor.…Now we're going to start by taking a look at using where,…and we're filtering to a specific partition in our data set.…If you recall in a previous clip,…what we had done was created this table sales_all_years…and added this partition of 2009,…so that actually limits the hive engine…when it tries to process this to a specific set of data…that was defined when we created our table.…If I run this query here, it's going to give us everything…
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