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 <brianh6854@googlemail.com>:

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