Hive Built-in Functions
Functions in Hive are categorized as below. Numeric and Mathematical Functions : These functions mainly used to perform mathematical calc...
Showing posts with the label Hive
Conditional Functions in Hive
Vijay Bhaskar
Hive supports three types of conditional functions. These functions are listed below: IF( Test Condition, True Value, False Value ) The...
String Functions in Hive
Vijay Bhaskar
The string functions in Hive are listed below: ASCII( string str ) The ASCII function converts the first character of the string into i...
Date Functions in Hive
Vijay Bhaskar
Date data types do not exist in Hive. In fact the dates are treated as strings in Hive. The date functions are listed below. UNIX_TIMESTA...
Difference between Normal Tables and External Tables in Hive
Vijay Bhaskar
The difference between the normal tables and external tables can be seen in LOAD and DROP operations. Normal Tables: Hive manages the no...
Numeric and Mathematical Functions in Hive
Vijay Bhaskar
The Numerical functions are listed below in alphabetical order. Use these functions in SQL queries. ABS ( double n ) The ABS function re...
Data Types in Hive
Vijay Bhaskar
Hive data types are categorized into two types. They are the primitive and complex data types. The primitive data types include Integers,...
What is Hive
Vijay Bhaskar
Hive data warehouse is used to manage large datasets residing in Hadoop and for querying purpose. Hive can be used to access files stored i...