While there is no UDF out of the box in hive to transpose/ pivot data, you could still achieve it by combination of CASE and COLLECT_SET/COLLECT_LIST
Refer here https://www.analyticshut.com/big-data/hive/pivot-rows-to-columns-in-hive/ Regards Suresh On Mon, Sep 9, 2019, 9:11 AM siva kumar <cvachap1...@gmail.com wrote: > Hi , > > How to Transpose?pivot rows and columns in hive > > Your help is appreciated. > > > cheers >
