title: hive table transpose operation using sql
body: <p>I want to transpose table using hive QL
  This is the souce table below</p>
  
  <pre><code>___________________________________________
  subject|roll_1|roll_2|roll_3|roll_4|roll_5|
  ___________________________________________
  MATHS  |80    | 90   |   78 |   95 |    68|
  ___________________________________________
  ENGLISH|78    | 78   | 67   |75    |54    |
  </code></pre>
  
  <p>and i want answer in the format as shown in the table below</p>
  
  <pre><code>subject|MATHS|ENGLISH|
  ______________________
  roll_1 |80   |78     |
  ______________________
  roll_2 |90   |78     |
  ______________________
  roll_3 |78   | 67    |
  ______________________
  roll_4 |95   |75     |
  ______________________
  roll_5 |68   |54     |
  </code></pre>
  
  <p>please help me to resove this</p>