https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Transpose-the-set-of-rows/m-p/148686#M48578 <P>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:</P><UL><LI><A href="http://stackoverflow.com/questions/23025380/how-to-transpose-pivot-data-in-hive" target="_blank">http://stackoverflow.com/questions/23025380/how-to-transpose-pivot-data-in-hive</A></LI><LI><A href="http://stackoverflow.com/questions/37436710/is-there-a-way-to-transpose-data-in-hive" target="_blank">http://stackoverflow.com/questions/37436710/is-there-a-way-to-transpose-data-in-hive</A></LI><LI><A href="http://hadoopmania.blogspot.com/2015/12/transposepivot-table-in-hive.html" target="_blank">http://hadoopmania.blogspot.com/2015/12/transposepivot-table-in-hive.html</A></LI></UL> Tue, 13 Dec 2016 03:42:15 GMT gkeys 2016-12-13T03:42:15Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Transpose-the-set-of-rows/m-p/148685#M48577 <P>How to achieve the following with inbuilt UDF in Hive?</P><TABLE><TBODY><TR><TD>1</TD><TD>35</TD></TR><TR><TD>2</TD><TD>22</TD></TR><TR><TD>3</TD><TD>45</TD></TR><TR><TD>4</TD><TD>64</TD></TR></TBODY></TABLE><P>To</P><TABLE><TBODY><TR><TD>1</TD><TD>2</TD><TD>3</TD><TD>4</TD></TR><TR><TD>35</TD><TD>22</TD><TD>45</TD><TD>64</TD></TR></TBODY></TABLE> Mon, 12 Dec 2016 16:32:47 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Transpose-the-set-of-rows/m-p/148685#M48577 ashsskum 2016-12-12T16:32:47Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Transpose-the-set-of-rows/m-p/148686#M48578 <P>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:</P><UL><LI><A href="http://stackoverflow.com/questions/23025380/how-to-transpose-pivot-data-in-hive" target="_blank">http://stackoverflow.com/questions/23025380/how-to-transpose-pivot-data-in-hive</A></LI><LI><A href="http://stackoverflow.com/questions/37436710/is-there-a-way-to-transpose-data-in-hive" target="_blank">http://stackoverflow.com/questions/37436710/is-there-a-way-to-transpose-data-in-hive</A></LI><LI><A href="http://hadoopmania.blogspot.com/2015/12/transposepivot-table-in-hive.html" target="_blank">http://hadoopmania.blogspot.com/2015/12/transposepivot-table-in-hive.html</A></LI></UL> Tue, 13 Dec 2016 03:42:15 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-Transpose-the-set-of-rows/m-p/148686#M48578 gkeys 2016-12-13T03:42:15Z