title: Hive: Extract Data From Nested JSON and Append
body: <p>I have a hive table with IDs and JSON such as below:</p>
  
  <pre><code>id   json
  ----------
  21 | {"temp":"3","list":[{"url":"aaa.com"},{"url":"bbb.com"}]}
  42 | {"temp":"2","list":[{"url":"qqq.com"},{"url":"vvv.com"}]}
  </code></pre>
  
  <p>The desired output is such as below:</p>
  
  <pre><code>id   url
  ----------
  21 | aaa.com
  21 | bbb.com
  42 | qqq.com
  42 | vvv.com
  </code></pre>
  
  <p>Would anyone help with this hive query?</p>
  
  <p>Applying explode() directly does not work as json column is a string.</p>