Hive Aggregate Functions (UDAF) with Examples
Hive Aggregate Functions are the most used built-in functions that take a set of values and return a single value,…
Hive Aggregate Functions are the most used built-in functions that take a set of values and return a single value,…
Like any other Database Hive also supports Relation, Arithmetic and Logical operators. Keeps an eye on return values as they…
Hive supports several date types like Hive Numeric Types Hive Date & Time Types Hive String Types Hive Misc Types…
Hive comes with a set of collection functions to work with Map and Array data types. These functions are used…
Use nvl() function in Hive to replace all NULL values of a column with a default value, In this article,…
Hive conditional functions are used to apply conditions on one or more columns and the conditions are executed for every…
Hive Date and Timestamp functions are used to manipulate Date and Time on HiveQL queries over Hive CLI, Beeline, and…
Hive supports several built-in string functions similar to SQL functions to manipulate the strings. These Hive string functions come in…
Hive CAST(from_datatype as to_datatype) function is used to convert from one data type to another for example to cast String…
This section of the Apache Hive Tutorial explains step-by-step Apache Hive Installation and configuring on Ubuntu. Apache Hive needs Apache…