Hive – Drop Table

Hive Tutorials

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) …

Read More ➜

Hive – Partitioning

Hive Tutorials

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 …

Read More ➜

Hive – Built-in Operators

Hive Tutorials

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 …

Read More ➜

Hive – Built-in Functions

Hive Tutorials

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 …

Read More ➜

Hive – Where Clause

Hive Tutorials

The Hive Query Language (HiveQL) is a query language for Hive to process and analyze structured data in a Meta-store. SELECT statement is used to …

Read More ➜