Log in
Skip to sidebar
Skip to main content
Linked Applications
Loading...
Apache Software Foundation
Spaces
Hit enter to search
Help
Online Help
Keyboard Shortcuts
Feed Builder
What’s new
What’s new
Available Gadgets
About Confluence
Log in
Apache Hive
Pages
Blog
Space shortcuts
How-to articles
Child pages
Pages
LanguageManual
LanguageManual Cli
LanguageManual DDL
LanguageManual DML
LanguageManual Select
LanguageManual Joins
LanguageManual LateralView
LanguageManual Union
LanguageManual SubQueries
LanguageManual Sampling
LanguageManual Explain
LanguageManual VirtualColumns
Configuration Properties
LanguageManual ImportExport
LanguageManual Authorization
LanguageManual Types
Literals
LanguageManual VariableSubstitution
LanguageManual ORC
LanguageManual WindowingAndAnalytics
LanguageManual Indexing
LanguageManual JoinOptimization
LanguageManual LZO
LanguageManual Commands
Parquet
Enhanced Aggregation, Cube, Grouping and Rollup
FileFormats
Hive HPL/SQL
24 more child pages
Browse pages
Configure
Space tools
View Page
A
t
tachments (0)
Page History
Page Information
View in Hierarchy
View Source
Delete comments
Export to PDF
Export to Word
Copy Page Tree
Pages
LanguageManual
Page History
Versions Compared
Old Version
43
changes.mady.by.user
Ian Cook
Saved on
Oct 04, 2018
compared with
New Version
Current
changes.mady.by.user
Ian Cook
Saved on
Oct 05, 2018
Previous Change: Difference between versions 42 and 43
View Page History
Key
This line was added.
This line was removed.
Formatting was changed.
Comment:
Add missing bullet before "Select"
...
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
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
Overview
Content Tools
Apps
{"serverDuration": 122, "requestCorrelationId": "b70c27b2206eab63"}