It is very rare that the usage of HIVE with JSON. But sometimes business requirements might force the developers to…
What is Minus operation? Below is a picture that shows Venn diagram of result of minus operation between two tables…
EXISTS EXISTS operator will be used when we need to check if there is any row exists with a condition.…
In this post we will see how we can extract unique records from a Hive table. This can be achieved…
One of the most frequent questions during Data Engineering interviews. These are called Ranking functions in Hive. These are the…
This post will focus on calculating moving average or sum using Hive queries. We might have come across this question…
Hive CLI and Beeline both can be used to interact with Hive execution engine. But there are few differences between…
Map join in Hive has several different names like Auto Map join, Map side join and Broadcast join. It is…
What is the use of GROUPING SETS clause in Hive queries? This is little bit rarely used clause but it…
How can you handle skewed data in Hive or Spark? How can we get rid of data skewness in Spark…