title: Json extract coming as null - Presto SQL
body: <p>I`m trying to use json extract to get some values using the code below:</p>
  <pre><code>json_extract_scalar(properties,'$.partner_target_app_id') as partner_target_app_id,
  </code></pre>
  <p>And it works, however the values are coming all as NULL . When I extract the properties field I get the values that I want, as the example below:
  {&quot;allow_url&quot;:false,&quot;partner_target_app_id&quot;:[28479748204829001,9388018374784],&quot;link&quot;:&quot;http&quot;}</p>
  <p>Does anybody know what could be the issue here? I thought it was something related to the [] around the numbers but I also tried to use '$.[partner_target_app_id]') and also got the same result.</p>
  <p>thanks</p>