Case 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 readingCategory: Hadoop
How 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 readingHow to add partition to an existing table in Hive?
ALTER TABLE ADD PARTITION in Hive Alter table statement is used to change the table structure or properties of an
Continue readingString replace functions in Apache Hive with examples
Hive provides few functions to handle the string replacement. Using string replace functions , we can replace some characters or
Continue readingHow to split the string based on pattern in Hive
Split function in Hive Hive providing many string functions to manipulate the strings. Split is one of the string function
Continue readingHow to set the different execution engine in Hive with examples
Execution engine in Hive Execution Engine used to communicate with Hadoop daemons such as Name node, Data nodes, and job
Continue readingInsert overwrite table values in Hive with examples
Insert overwrite table in Hive The insert overwrite table query will overwrite the any existing table or partition in Hive.
Continue reading