title: SQL JSON array sort
body: <p>record in DB:</p>
  
  <pre><code>id     info
  0     [{"name":"a", "time":"2017-9-25 17:20:21"},{"name":"b", "time":"2017-9-25 23:23:41"},{"name":"c", "time":"2017-9-25 12:56:78"}]
  </code></pre>
  
  <p>my goal is to sort json array column <code>info</code> base on <code>time</code>, like:</p>
  
  <pre><code>id     info
  0     [{"name":"c", "time":"2017-9-25 12:56:78"},{"name":"a", "time":"2017-9-25 17:20:21"},{"name":"b", "time":"2017-9-25 23:23:41"},]
  </code></pre>
  
  <p>I use sparkSQL, having no clue</p>