Apache Hive introduced a function named “current_user()” from version 1.2.0 which returns the current user name from the authenticator manager configured. It could be the
Category: Apache Hive
Substring_Index Function in Apache Hive
The aim of this post is to let you know how to use the SUBSTRING INDEX() function to get a substring from a string until
Get Version Of Apache Hive
If you are using Apache Hive 2.1.0 or later versions, you can SELECT VERSION() function in the Apache Hive prompt to get the version. Otherwise,
Usage of Collect_Set Function in Apache Hive
Collect_Set is one of the aggregate functions that help in return a set of objects with duplicate elements eliminated. This will help in bringing the
Type Conversion Functions in Apache Hive
One of the commonly used functions in RDBMS is the CAST function, which helps to transform the expression of one data type to another data
Identify Months Between Two Dates – Apache Hive & Impala
The function MONTHS_BETWEEN returns the number of months between the dates specified. If the first expression is later than the second, the outcome is positive,
Big Data & SQL 