RLIKE (Regular expression) function in Hive with examples
RLIKE function in Hive RLIKE function is an advanced version of LIKE operator in Hive. It is used to search
Continue readingCategory: Hadoop
Current timestamp in Hive with examples
Timestamp values in Hive Timestamp values are required to capture the time along with date values. Hive provides few date
Continue readingHow to use ROW NUMBER function in Hive?
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
Continue readingRegexp_extract function in Hive with examples
Regexp_extract function in hive In the programming languages, Regular expression is used to search the certain pattern on the string
Continue readingSubstring function in Hive with examples
Hive substring : Substring is a built-in string function in Hive which is used to extract a part of a
Continue readingCase Statement in Hive with examples
Case Statement in Hive Hive supports Case statements to check the conditions against the column values. If any of the
Continue readingHow to get the Current Date in Hive with examples
Current date in Hive Hive provides many date functions to handle the date and time values in the tables. Current_date
Continue readingHow to rename a table in Hive?
Alter table statement in Hive Alter table statement helps to change the structure of the table in Hive. It allows
Continue readingCopy the data or table structure from one table to another in Hive
In some cases, you may want to copy or clone or duplicate the data ,structure of Hive table to a
Continue readingInsert into table in Hive with examples
Insert into query in Hive Hive support INSERT INTO syntax starting in version 0.8. We can write the insert query
Continue reading
