blob: db131076c1044ed0dc82a3f2c50b410a8a228584 [file] [log] [blame]
select d.uid, flatten(d.map.rm), flatten(d.events) from `data.json` d where d.map.rm[0].rptd[0].a = 'foo1' and d.events[4].type = 'cmpgn2';