Normal user-defined functions take in a single input row and output a single output row. In contrast, table-generating functions transform a single input row to
Tag: EXPLODE and SPLIT functions in HIVE
Is Complex Data Really Complex To Handle?
Let’s split the title-question into two. What is the complex data and how complex it is to handle. First, let’s see what complex data is.
Convert Delimited Data Into Columns In MySQL
This article addresses the conversion of the delimited data into columns in MySQL. There are is a function called “SUBSTRING_INDEX” that helps us convert the
Convert Delimited Data Into Columns In SQL Server
This article addresses the conversion of the delimited data into columns in SQL Server. There are two functions called “STRING_SPLIT” and “PARSENAME” that helps us
Convert Delimited Data Into Columns In Hive
The conversion of delimited data into columns in Apache Hive is discussed in this article. If the data is already loaded as a single column
Word Count in HiveQL – Explode and Split Usage
This article aims to explain the usage of the SPLIT function in HiveQL. If you are looking for a similar function in SQL Server, then
Big Data & SQL 