Categories

There are currently no items in your shopping cart.

User Panel

Forgot your password?.

From 0 to 1: Hive for Processing Big Data

You, Us & This Course
Hive: An Open-Source Data Warehouse
Hive and Hadoop
Hive vs Traditional Relational DBMS
HiveQL and SQL
Hadoop Install Modes
Hadoop Install Step 1: Standalone Mode
Hadoop Install Step 2: Pseudo-Distributed Mode
Hive install
Code-Along: Getting started
What is Hadoop?
HDFS or the Hadoop Distributed File System
Primitive Datatypes
Collections_Arrays_Maps
Structs and Unions
Create Table
Insert Into Table
Insert into Table 2
Alter Table
HDFS
HDFS CLI - Interacting with HDFS
Code-Along: Create Table
Code-Along: Hive CLI
Three types of Hive functions
The Case-When statement, the Size function, the Cast function
The Explode function
Code-Along: Hive Built - in functions
Quirky Sub-Queries
More on subqueries: Exists and In
Inserting via subqueries
Code-Along: Use Subqueries to work with Collection Datatypes
Views
Indices
Partitioning Introduced
The Rationale for Partitioning
How Tables are partitioned
Using Partitioned Tables
Dynamic Partitioning: Inserting data into partitioned tables
Code-Along: Partitioning
Introducing Bucketing
The Advantages of Bucketing
How Tables are bucketed
Using Bucketed Tables
Sampling
Windowing Introduced
Windowing - A Simple Example: Cumulative Sum
Windowing - A More Involved Example: Partitioning
Windowing - Special Aggregation Functions
The basic philosophy underlying MapReduce
MapReduce - Visualized and Explained
MapReduce - Digging a little deeper at every step
MapReduce Overview: Basic Select-From-Where
MapReduce Overview: Group-By and Having
MapReduce Overview: Joins
Improving Join performance with tables of different sizes
The Where clause in Joins
The Left Semi Join
Map Side Joins: The Inner Join
Map Side Joins: The Left, Right and Full Outer Joins
Map Side Joins: The Bucketed Map Join and the Sorted Merge Join
Custom functions in Python
Code-Along: Custom Function in Python
Introducing UDFs - you're not limited by what Hive offer
The Simple UDF: The standard function for primitive types
The Simple UDF: Java implementation for replacetext()
Generic UDFs, the Object Inspector and DeferredObjects
The Generic UDF: Java implementation for containsstring()
The UDAF: Custom aggregate functions can get pretty complex
The UDAF: Java implementation for max()
The UDAF: Java implementation for Standard Deviation
The Generic UDTF: Custom table generating functions
The Generic UDTF: Java implementation for namesplit()
Select Statements
Select Statements 2
Operator Functions
Aggregation Operators Introduced
The Group by Clause
More Group by Examples
Order by
Having
Introduction to SQL Joins
Cross Joins and Cartesian Joins
Inner Joins
Left Outer Joins
Right, Full Outer Joins, Natural Joins, Self Joins
[For Linux/Mac OS Shell Newbies] Path and other Environment Variables

You Have Got Gift 25% OFF

Use this Coupon Code “J3JKN396