Here are several examples with explanations and sample datasets for practicing SerDe. This post contains a compilation of all of the articles previously published on
Tag: hiveql
Joins in HiveQL
As we discussed earlier, HiveQL handles structured data only, much like SQL. This doesn’t mean that Hive just manages structured data, it also processes and
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
Commonly used Apache Hive non-SQL Statements
Commands are non-SQL statements such as setting a property or adding a resource. They can be used in HiveQL scripts or directly in the CLI or Beeline. The
An alternative to ISNULL() and NVL() functions in Hive
The NVL() function enables you to substitute null for a more relevant alternative in the query results. This function accepts two arguments. If the first
Big Data & SQL 