Category: Hadoop

Extract function in Hive with examples

Extract function in Hive Extract function is used to get the date or time part values from a Date/Timestamp/Interval/String that

Concat function in Hive The concat() function add two or more strings or bytes together. If any of the value

COALESCE function in Hive Coalesce is a conditional function in Hive which is used to handle the NULL values. It

Explode function in Hive Explode is a User Defined Table generating Function(UDTF) in Hive. It takes an array (or a

Google Cloud Storage (GCS) Google Cloud Storage is a secure and scalable storage option offered by Google. It allows us

Apache Hive Apache Hive is an open source data warehousing solution build on top of Hadoop. It supports SQL-like query

Alter table statement in Hive The Alter table statement is used to change the structure of the existing table in

Trim function in Hive Trim function removes the extra space from both ends of the string value. In other words,

Apache spark to write a Hive Table Apache Spark provides an option to read from Hive table as well as

Hive instr function Instr is a string function which returns the position of the first occurrence of substring in the