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 …
Hive – View and Indexes
Views are generated based on user requirements. You can save any result set data as a view. The usage of view in Hive is same …
Hive – Where Clause
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 …
Hive – Order By Clause
The ORDER BY clause is used to retrieve the details based on one column and sort the result set by ascending or descending order. Syntax …
Hive – Group By Query
The GROUP BY clause is used to group all the records in a result set using a particular collection column. It is used to query …
