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.