Skip to Main Content
Apache Hive Essentials - Second Edition
book

Apache Hive Essentials - Second Edition

by Dayong Du
June 2018
Beginner to intermediate content levelBeginner to intermediate
210 pages
5h 12m
English
Packt Publishing
Content preview from Apache Hive Essentials - Second Edition

INNER JOIN

INNER JOIN or JOIN returns rows meeting the join conditions from both sides of joined tables. The JOIN keyword can also be omitted by comma-separated table names; this is called an implicit join. Here are examples of the HQL JOIN operation:

  1. First, prepare a table to join with and load data to it:
      > CREATE TABLE IF NOT EXISTS employee_hr (      > name string,      > employee_id int,      > sin_number string,      > start_date date      > )      > ROW FORMAT DELIMITED      > FIELDS TERMINATED BY '|';      No rows affected (1.732 seconds)            > LOAD DATA INPATH '/tmp/hivedemo/data/employee_hr.txt'      > OVERWRITE INTO TABLE employee_hr;      No rows affected (0.635 seconds)
  1. Perform an INNER JOIN between two tables with equal and unequal join conditions, along with complex expressions ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Apache Hive Essentials

Apache Hive Essentials

Dayong Du
Apache Hive Cookbook

Apache Hive Cookbook

Hanish Bansal, Saurabh Chauhan, Shrey Mehrotra
Apache Spark Quick Start Guide

Apache Spark Quick Start Guide

Shrey Mehrotra, Akash Grade

Publisher Resources

ISBN: 9781788995092Supplemental Content