At the end of this video the student will know how to run a basic SELECT statement in Hive and what other options Hive supports.
- [Voiceover] Now let's take a look…at retrieving data from Hive with the select statement.…The select statement is a foundational part…of the SQL language,…and what it does is, it allows us to ask the database,…Hive in this case, for some data back,…for some data to be returned.…What we're going to do here is,…take a look at the structure of the select statement,…so you understand all the different parts of it.…Then I'll go through some simple examples…and show you how to actually write them.…Then I'll show you even how to save…some keystrokes with aliases.…Right, back here in my Cloudera environment,…I'm going to look at the scripts…that come with the exercise files for this course,…and I'm going to open up 3-1.sql.…
Click display, and we're just going to copy this…into our Hive editor.…So, here in the Hive editor, I want to first just talk about…the structure of a select statement.…So here are all the components,…or the majority of the components,…that you're going to come across, with using select.…It starts by the word select,…
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