Hive of how to implement the table since the associated query, if the udf function and how to implement

The sample layer (50)

Child_id parent_id
2 1
3 2
4 3

Finally to generate the results should be four fields of the table
C1 c2 c3 c4
1 2 3 4

For guidance, THX