From the course: Analyzing Big Data with Hive
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Combining tables with JOIN - Hive Tutorial
From the course: Analyzing Big Data with Hive
Combining tables with JOIN
- [Narrator] Okay, now we're going to take a look at how to combine tables using JOIN. Now, JOIN is a function in which Hive will allow you to combine these different tables to create a more comprehensive result set. JOIN isn't something unique to Hive. This is an anti standard feature of SQL and really a fundamental thing to understand when you're just working with databases, as it's really common to separate out different data into separate tables. Now one thing to note about Hive is that it only supports EQUI JOINs, that's joins that use the equals operator. So, at this stage you may not be thinking, why else would you use a different operator? But rest assured, there are other databases and cases where you come across where you may want to have a non equal, or greater than, or less than in your actual join condition. Here in Hive, that's just not supported currently. Let's first take a look at just some of the join types, and the first one of course is the most common, which is an…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.