title: Finding the First & Last of Array struct
body: <p>Having an array struct in file like below</p>
  
  <pre><code>[{"A":"1","B":"2","C":"3"},{"A":"4","B":"5","C":"6"},{"A":"7","B":"8","C":"9"}]
  </code></pre>
  
  <p>How can I get the first &amp; last value of column <code>"A" ("1","7")</code></p>
  
  <p>Need to write in Hive <strong>SQL</strong>.</p>
  
  <p>Thanks in advance.</p>