Let Us explore and learn .
If you have not already, follow me to stay updated
There are multiple use cases when we need to transpose/pivot table and Hive does not provide us with easy function to do so. Let me show you workaround for how to pivot table in hive.
There are many advanced aggregate functions in hive. Lets take a look at look at collect_set and collect_list and how can we use them effectively.