Apache Hive : LanguageManual

This is the Hive Language Manual.  For other Hive documentation, see the Hive wiki’s Home page.

• Commands and CLIs

  • Commands
  • Hive CLI (old)
  • Beeline CLI (new)
  • Variable Substitution
  • HCatalog CLI

• File Formats

  • Avro Files
  • ORC Files
  • Parquet
  • Compressed Data Storage
  • LZO Compression

• Data Types

• Data Definition Statements

  • DDL Statements
    • Bucketed Tables
    • Write Ordering (Type-Native & Z-Order)
  • Statistics (Analyze and Describe)
  • Indexes
  • Archiving

• Data Manipulation Statements

  • DML: Load, Insert, Update, Delete
  • Import/Export

• Data Retrieval: Queries

  • Select
    • Group By
    • Sort/Distribute/Cluster/Order By
    • Transform and Map-Reduce Scripts
    • Operators and User-Defined Functions (UDFs)
    • XPath-specific Functions
    • Joins
    • Join Optimization
    • Union
    • Lateral View
  • Sub Queries
  • Sampling
  • Virtual Columns
  • Windowing and Analytics Functions
  • Enhanced Aggregation, Cube, Grouping and Rollup
  • Procedural Language:  Hive HPL/SQL
  • Explain Execution Plan

• Locks

• Authorization

  • Storage Based Authorization
  • SQL Standard Based Authorization
  • Hive deprecated authorization mode / Legacy Mode

• Configuration Properties