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, when used with a group, it aggregates all values in…
0 Comments
November 18, 2020
Hive Relational | Arithmetic | Logical Operators
Like any other Database Hive also supports Relation, Arithmetic and Logical operators. Keeps an eye on return values as they changes if one of the operand is NULL. Hive Relational…
November 16, 2020
Hive Data Types – Primitive | Complex
Hive supports several date types like Hive Numeric TypesHive Date & Time TypesHive String TypesHive Misc Types (Boolean & Binary)Hive Complex Types (Array, Map, Struct) Hive Numeric Types Below are…
November 16, 2020
Hive Collection Functions with Examples
Hive comes with a set of collection functions to work with Map and Array data types. These functions are used to find the size of the array, map types, get…
November 15, 2020
How to replace NULL values with Default in Hive
Use nvl() function in Hive to replace all NULL values of a column with a default value, In this article, I will explain with an example. You can use this…
November 15, 2020
Hive Conditional Functions with Examples
Hive conditional functions are used to apply conditions on one or more columns and the conditions are executed for every row on a table. In this article, you will learn…
November 15, 2020
Hive Date and Timestamp Functions | Examples
Hive Date and Timestamp functions are used to manipulate Date and Time on HiveQL queries over Hive CLI, Beeline, and many more applications Hive supports. The default date format of…
November 15, 2020
Hive Built-in String Functions with Examples
Hive supports several built-in string functions similar to SQL functions to manipulate the strings. These Hive string functions come in handy when you are doing transformations without bringing data into…
November 10, 2020
Hive Cast Function to Convert Data Type
Hive CAST(from_datatype as to_datatype) function is used to convert from one data type to another for example to cast String to Integer(int), String to Bigint, String to Decimal, Decimal to…
November 8, 2020
Apache Hive Installation on Ubuntu
This section of the Apache Hive Tutorial explains step-by-step Apache Hive Installation and configuring on Ubuntu. Apache Hive needs Apache Hadoop Installation to be set up and running HDFS as…
November 7, 2020