Chapter 9. Functions in Hive
Hive provides an extensive set of functions that we will be covering in this chapter; they are as follows:
- Using built-in functions
- Using the built-in User defined Aggregation Function (UDAF)
- Using the built-in User Defined Table Function (UDTF)
- Creating custom User-Defined Functions (UDF)
Using built-in functions
There are various built-in functions available in Hive that can be used in queries for executing various operations. These functions are used to extract or manipulate data in Hive tables.
Built-in functions are divided into the following categories:
- Mathematical functions
- Collection functions
- Type conversion functions
- Date functions
- String functions
- Conditional functions
- Miscellaneous functions
How to do it…
In the following ...
Get Apache Hive Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
