3 May
2016
3 May
'16
12:29 a.m.
Hi Brian, thanks for your response.
Is there a way to filter what I need inside the first SELECT?
Something like this? ...
SELECT id,
json.filter(json_data, '$.data.[?(time=2015-10-09*)]') AS time, /* I know
this does not work, but it's in an example */
(...other fields...)
FROM tbljson;
2016-05-02 18:51 GMT-03:00 Brian Hood
Hi Alberto,
I think this should help.
SELECT id, json.filter(json_data, '$.data.time') AS time, json.filter(json_data, '$.data.others') AS others, FROM tbljson;
Regards,
Brian Hood