blob: 27e688a807a5a7346dee74d8d8a6fc1827d9fa65 [file] [log] [blame]
select * from (select d.uid uid, flatten(d.events) evnts from `data.json` d order by d.uid) s order by s.evnts.campaign_id, s.evnts.event_time;