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: Cloudera Impala
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.
Type Conversion Functions in Apache Hive
One of the commonly used functions in RDBMS is the CAST function, which helps to transform the expression of one data type to another data
Big Data & SQL 