hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <richin.j...@nokia.com>
Subject Converting rows into dynamic colums in Hive
Date Tue, 07 Aug 2012 20:57:59 GMT
Hi All,

One of my Query output looks like-

Alpha                    Beta                       Gamma
123                         xyz                         1.0
123                         abc                         0.5
123                         pqr                         1.3
123                         def                         2.1
456                         xyz                         0.1
456                         abc                         0.6
456                         pqr                         1.9
456                         def                         3.2
456                         lmn                        1.1
456                         sdf                          1.2

I want the output for the data visualization purpose to look like (basically taking rows from
one table and making it column in another table)

Alpha                    xyz         abc         pqr         def         lmn        sdf
123                         1.0          0.5          1.3          2.1
456                         0.1          0.6          1.9          3.2          1.1      
   1.2

Question - Can it be done in Hive? If not, any suggestions.

Thanks,
Richin



Mime
View raw message