The conditional functions available in the Apache Hive are as follows. The most of them are also available in Apache Impala. The behavior of the
Category: Apache Hive
Apache Hive Date Time Functions
The date time functions available in the Apache Hive are as follows. The most of them are also available in Apache Impala. The behavior of
Apache Hive Aggregate Functions – Part-2
This is continuation part of “Apache Hive Aggregate Functions” Function: VARIANCE & VAR_POP Returns the population variance of the total number of records present in
Apache Hive Aggregate Functions – Part-1
In both traditional relational systems and big data technologies such as Apache Hive and Apache Impala, most of the functions specified in this series are
Dividing an ordered partition into groups – Apache Hive & Apache Impala
The NTILE function divides the ordered partition into a specified number of bucket groups and assigns a bucket number to each row in the partition.
Usage of Collect_List function in Apache Hive
Collect_List is one of the aggregate functions that help in return a set of objects with duplicate elements. This is similar to COLLECT_SET and will
Big Data & SQL 