Hive

• Hive Introduction
  • What is Hive
    • Hive is not
  • Features of Hive
  • Architecture of Hive
  • Working of Hive
  • References
• Hive Installation
  • Pre-Installation Setup
  • Installing Hive
  • Configuring Hive
  • Downloading and Installing Apache Derby
    • Results
    • ij
  • Configuring Metastore of Hive
  • Verifying Hive Installation
  • Tips
  • References
• Hive Data Types
  • Column Types
    • Integral Types
    • String Types
    • Timestamp
    • Dates
    • Decimals
    • Union Types
  • Literals
    • Floating Point Types
    • Decimal Type
  • Null Value
  • Complex Types
    • Arrays
    • Maps
    • Structs
  • References
• Hive Database
  • Create Database
    • Create Database Statement
    • JDBC Program
    • Tips
  • Drop Database
    • Drop Database Statement
    • JDBC Program
  • References
• Hive Table
  • Create Table
    • Create Table Statement
    • Load Data Statement
  • Alter Table
    • Alter Table Statement
    • Rename To… Statement
    • Change Statement
    • Add Columns Statement
    • Replace Statement
  • Tips
  • Drop Table
    • Drop Table Statement
  • References
• Hive Partitioning
  • Adding a Partition
  • Renaming a Partition
  • Dropping a Partition
  • References
• Hive Built-in Operators
  • Relational Operators
    • Tips
    • Example
  • Arithmetic Operators
    • Example
  • Logical Operators
    • Example
  • Complex Operators
  • References
• Hive Built-in Functions
  • Built-In Functions
    • Example
  • Aggregate Functions
  • References
• Hive View and Indexes
  • Creating a View
    • Example
  • Dropping a View
  • Creating an Index
    • Example
  • Dropping an Index
  • References
• HiveQL
  • Select-Where
    • Syntax
    • Example
    • JDBC Program
  • Select-Order By
    • Syntax
    • Example
    • JDBC Program
  • Select-Group By
    • Syntax
    • Example
    • JDBC Program
  • Select-Joins
    • Syntax
    • Example
    • JOIN
    • LEFT OUTER JOIN
    • RIGHT OUTER JOIN
    • FULL OUTER JOIN
  • References
• Hive vs. HBase
  • Summary
  • NoSQL and Big Data Processing
  • References