Framework Repositories
latest
Big Data
Apache
Cloudera
Flume
Hadoop
HBase
Hive
Hive Introduction
Hive Installation
Hive Data Types
Hive Database
Hive Table
Hive Partitioning
Hive Built-in Operators
Hive Built-in Functions
Hive View and Indexes
HiveQL
Hive vs. HBase
Impala
Pig
Kafka
Solr
Spark
Storm
Databases
DevOps
Docker
Framework
Linux
MQ
Network
Open Source
Proxy
REST
RPC
Spring
Spring Boot
ZooKeeper
Framework Repositories
Big Data
Hive
Edit on GitHub
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
Read the Docs
v: latest
Versions
latest
Downloads
On Read the Docs
Project Home
Builds