Category: Hadoop

Length function in Hive with examples

Length function in Hive The length function returns the length of a specified string. In other words, it gives the

RLIKE function in Hive RLIKE function is an advanced version of LIKE operator in Hive. It is used to search

Timestamp values in Hive Timestamp values are required to capture the time along with date values. Hive provides few date

ROW_NUMBER() function in Hive Row_number is one of the analytics function in Hive. It will assign the unique number(1,2,3…) for

Regexp_extract function in hive In the programming languages, Regular expression is used to search the certain pattern on the string

Hive substring : Substring is a built-in string function in Hive which is used to extract a part of a

Case Statement in Hive Hive supports Case statements to check the conditions against the column values. If any of the

Current date in Hive Hive provides many date functions to handle the date and time values in the tables. Current_date

Alter table statement in Hive Alter table statement helps to change the structure of the table in Hive. It allows

In some cases, you may want to copy or clone or duplicate the data ,structure of Hive table to a