Skip to content
Advertisement

Easy table transpose in hive

I need to transpose my table. Now i have that type of table:

But i want to get the next result

How should i transpose my table for achieving this result?

Advertisement

Answer

Use case statements with min() or max() aggregation:

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement