The string functions available in the Apache Hive are as follows. The most of them are also available in Apache Impala. The behavior of the
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Apache Hive Conditional Functions
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
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.
Big Data & SQL 