Is there a way to transpose data in Hive
<p>This is my table:</p>

<pre><code>pid     high    medium    low
1       10      8         6
2       20      16        12
3       10      6         4
</code></pre>

<p>I want store this data in another table in Hive with the following format:</p>

<pre><code>pid      priority      value
1         high          10 
1         medium        8
1         low           6
2         high          20
2         medium        16
2         low           12
3         high          10
3         medium        6
3         low           4
</code></pre>