title: How to get all values of an attribute of json array with jsonpath bigquery in bigquery? Asterisk operator not supported.
body: <p>I'm trying to get all the values of a certain attribute from a json array.
  Considering the following json, I'm trying to get all the types e.g. iPhone,home</p>
  
  <pre><code>{
   "firstName": "John",
   "lastName" : "doe",
   "age"      : 26,
   "address"  :
   {
       "streetAddress": "naist street",
       "city"         : "Nara",
       "postalCode"   : "630-0192"
   },
   "phoneNumbers":
   [
       {
         "type"  : "iPhone",
         "number": "0123-4567-8888"
       },
       {
         "type"  : "home",
         "number": "0123-4567-8910"
       }
   ]
  }
  </code></pre>
  
  <p>I am using <code>$.phoneNumbers[*].type</code> which seems to work fine on <a href="http://ashphy.com/JSONPathOnlineEvaluator/?" rel="nofollow">online parsers</a>
  but when I'm using it in big query:</p>
  
  <pre><code>select json_extract(my_column,'$.phoneNumbers[*].type')
  from my_table
  </code></pre>
  
  <p>I get:</p>
  
  <pre><code>JSONPath parse error at: [*].type
  </code></pre>