Hive – Installation
All Hadoop sub-projects such as Hive, Pig, and HBase support Linux operating system. Therefore, you need to install any Linux flavored OS. The following simple …
Hive – Data Types
All the data types in Hive are classified into four types, given as follows: Column Types Literals Null Values Complex Types Column Types Column type …
Hive – Create Database
Hive is a database technology that can define databases and tables to analyze structured data. The theme for structured data analysis is to store the …
Hive – Drop Database
The usage of SCHEMA and DATABASE are same. Drop Database Statement Drop Database is a statement that drops all the tables and deletes the database. …
Hive – Create Table
The conventions of creating a table in HIVE is quite similar to creating a table using SQL. Create Table Statement Create Table is a statement …
Hive – Alter Table
Alter Table Statement It is used to alter a table in Hive. Syntax The statement takes any of the following syntaxes based on what attributes …
Hive – Drop Table
When you drop a table from Hive Metastore, it removes the table/column data and their metadata. It can be a normal table (stored in Metastore) …
