title: Hive QL selecting numeric substring of string
body: <p>I have a table with two columns: <code>id, datastring</code></p>
  
  <p>The id column is just a bigint and the datastring column has elements that look like </p>
  
  <pre><code>{"12345":[6789,true]}
  
  {"1234678":[5678, false]}
  </code></pre>
  
  <p>I would like to select a table where the first column is the id and the second column is the number in the quotes part of the datastring.  However, this number is not always the same number of digits.</p>
  
  <p>The result should be </p>
  
  <pre><code>id, numstring
  
  4321, 12345
  4322, 134678
  </code></pre>
  
  <p>Thanks in advance.</p>