This message was deleted.

Hi Vimil, if this is just a query, then something like:

select min(__time) as "__time", 
       channel, 
       ARRAY_AGG(distinct flags) flagArr, 
       count(*) "__count" 
  from wikipedia 
 group by channel

If you want to reingest it into a new table, then I'm not sure about the restrictions here.

Thanks @John Kowtko this helps. I thin kI can use this query in sql based ingestion task to ingest the rolled up rows into a separate table.