Hive:Transpose the set of rows

[#1]

How to achieve the following with inbuilt UDF in Hive?

1	35
2	22
3	45
4	64

To

1	2	3	4
35	22	45	64

[#2 · Accepted solution]

There is no out-of-the box UDF to do this in Hive. You need to build it yourself using Hive's map function. Examples:

• http://stackoverflow.com/questions/23025380/how-to-transpose-pivot-data-in-hive
• http://stackoverflow.com/questions/37436710/is-there-a-way-to-transpose-data-in-hive
• http://hadoopmania.blogspot.com/2015/12/transposepivot-table-in-hive.html