title: Parse json array and load into a table
body: <p>I'm having issues with parsing a json array and loading into a hive table.</p>
  <p>Json array lives in table dmetrics and in column <code> metrics</code></p>
  <p>The json looks like this&quot;</p>
  <pre><code>{&quot;impressions&quot;:8256,&quot;requests&quot;:67.....
  </code></pre>
  <p>I keep getting the following error :</p>
  <blockquote>
  <p>{&quot;cannot resolve 'get_json_object(dmetrics.<code>metrics</code>, '$.imppressions')' due to data type mismatch: argument 1 requires string type, however, 'dmetrics.<code>metrics</code>' is of struct&lt;confirmedimpressions:bigint,requests:bigint,....</p>
  </blockquote>
  <p>I'm using the following code:</p>
  <pre><code>get_json_object(dmetrics.metrics, '$.impression.included)
  </code></pre>