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.

Creating tables in Hive

Creating tables in Hive - Hive Tutorial

From the course: Analyzing Big Data with Hive

Start my 1-month free trial

Creating tables in Hive

- [Male Narrator] Now let's take a look at actually creating tables in Hive. The first thing we're going to so is open the HUE Metastore Manager and take a look at what's there, then we'll upload a file that you get with the downloads for this course, and then we'll browse data and some of the other tables that are there. Here in my HUE editor, I have my Hive examples, and the first thing I want to do is actually just open up the file browser here, so I'm going to go to application, system tools, file browser, and I'm going to browse to the shared folder with the exercise files that we set up in our virtual environment. Inside of here, I'm going to go into the data folder, and I'm going to take a look at this CogsleyServices-SalesData-US-NoCommas.csv. Now, I have that one there, and then I have another one with commas, so if we just take a look at this. I'll double click it, choose display, and, if I maximize this, it's a bunch of stuff on the screen, but essentially what we have on…

Contents