You may try turn on this option `store.json.all_text_mode`, and then
cast into numeric value in the query explicitly.
alter session set `store.json.all_text_mode` = true;
On Wed, Apr 19, 2017 at 8:49 AM, Dela Cruz, Vergel
wrote:
> Hi,
>
>
>
> I have a case where 2 json files from AQI website hav
Hi,
I have a case where 2 json files from AQI website have similar format except
that the geo lat/lng have can sometimes have double quotes.
This is causing an error when I run the query. If I remove the double quotes
from the file then it works so I'm pretty sure it's the double quotes
that's g
