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. …
myTechMint
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) …
Hive – Partitioning
Hive organizes tables into partitions. It is a way of dividing a table into related parts based on the values of partitioned columns such as …
Hive – Built-in Operators
There are four types of operators in Hive: Relational Operators Arithmetic Operators Logical Operators Complex Operators Relational Operators These operators are used to compare two …
Hive – Built-in Functions
The functions look quite similar to SQL functions, except for their usage. Built-In Functions Hive supports the following built-in functions: Return Type Signature Description BIGINT …
