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 readingCategory: Hadoop
Coalesce 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 readingHow to access a Hive table using Pyspark?
Pyspark Apache Spark is an in-memory data processing framework written in Scala language. It process the data 100 times faster
Continue reading