From the course: Analyzing Big Data with Hive
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Simple SELECT statement - Hive Tutorial
From the course: Analyzing Big Data with Hive
Simple SELECT statement
- [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…
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.