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
Continue readingCategory: Hadoop
Concat and concat_ws function in Hive with examples
Concat function in Hive The concat() function add two or more strings or bytes together. If any of the value
Continue readingCoalesce function in Hive with examples
COALESCE function in Hive Coalesce is a conditional function in Hive which is used to handle the NULL values. It
Continue readingExplode function in Hive with examples
Explode function in Hive Explode is a User Defined Table generating Function(UDTF) in Hive. It takes an array (or a
Continue readingCreate a Hive External table on Google Cloud Storage(GCS)
Google Cloud Storage (GCS) Google Cloud Storage is a secure and scalable storage option offered by Google. It allows us
Continue readingParsing Hive Create table query using Apache Hive library
Apache Hive Apache Hive is an open source data warehousing solution build on top of Hadoop. It supports SQL-like query
Continue readingHow to rename a column in Hive?
Alter table statement in Hive The Alter table statement is used to change the structure of the existing table in
Continue readingTrim function in Hive with examples
Trim function in Hive Trim function removes the extra space from both ends of the string value. In other words,
Continue readingHow to write a Spark dataframe to Hive table in Pyspark?
Apache spark to write a Hive Table Apache Spark provides an option to read from Hive table as well as
Continue readingInstr function in Hive with examples
Hive instr function Instr is a string function which returns the position of the first occurrence of substring in the
Continue reading