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