title: How to get chained data from hive query?
body: <p>I have tableA:</p>
  
  <pre><code>id  colA colB(Chained)
  1   11   17
  2   22   41
  3   44   42
  4   82   43
  5   17   13
  6   20   85
  7   26   90
  8   13   19
  9   19   82
  </code></pre>
  
  <p>I want result set of chained data like below from hive query:</p>
  
  <pre><code>id  ChainedCol(from colA)   colB
  1   11                      17
  5   17                      13
  8   13                      19
  9   19                      82
  4   82                      43
  </code></pre>