Press "Enter" to skip to content

Unpivoting Data in Hive

The Big Data in Real World team does a bit of data reshaping:

Let’s say we have a table name  employee_multiple_depts and each employee in the table is mapped to 3 departments – dept1, dept2 and dept3.

What we need is to transpose or convert each department into a row for each employee.

Click through to see how you can do it in Hive.