Notes, Hive Tutorial

Contents
  1. 1. Acknowledge
  2. 2. Introduction
    1. 2.1. Big Data
    2. 2.2. Syntax
  3. 3. Reference

Last Modified: 2017-08-28 16:49:00

Acknowledge

  • What is Hive?
    Hive is a data warehouse infrastructure tool to process structured data in Hadoop. It resides on top of Hadoop to summarize Big Data, and makes querying and analyzing easy.

  • Official Hive Tutorial
    Tutorial

Introduction

Hive - Introduction

Big Data

  • Hadoop
    • MapReduce
    • HDFS
  • Tools

    • Sqoop
    • Pig
    • Hive
  • Hive
    see the link above for details

Syntax

Syntax is omitted, see the reference for details

  • Views And Indexes
    Difference between view and index
  • Select Joins
    Inner Join vs Outer Join
    Inner Join vs Natural Join, Natural Join is just short syntax for a specific Inner Join

    • JOIN (same as INNER JOIN)
      JOIN clause is used to combine and retrieve the records from multiple tables.
      (It only shows the matched result)
    • LEFT OUTER JOIN
      LEFT OUTER JOIN returns all the rows from the left table, even if there are no matches in the right table. This means, if the ON clause matches 0 (zero) records in the right table, the JOIN still returns a row in the result, but with NULL in each column from the right table.
    • RIGHT OUTER JOIN
      RIGHT OUTER JOIN returns all the rows from the right table, even if there are no matches in the left table. If the ON clause matches 0 (zero) records in the left table, the JOIN still returns a row in the result, but with NULL in each column from the left table.
    • FULL OUTER JOIN
      FULL OUTER JOIN combines the records of both the left and the right outer tables that fulfil the JOIN condition. The joined table contains either all the records from both the tables, or fills in NULL values for missing matches on either side.

Reference

Learn Hive
Hive Language Manual


1. 除非注明,本博文即为原创,转载请注明链接地址
2. 本博文只代表博主当时的观点或结论,请不要恶意攻击
3. 如果本文帮到了您,不妨点一下 下面分享到 按钮,让更多的人看到