athena.sql

WITH aggregated_metrics AS (
  SELECT arbitrary(pop) AS pop, arbitrary(idx) AS idx, SUM(m) as m
  FROM (
    VALUES
      (1,  ARRAY[2, 5, 7]),
      (2,  ARRAY[45, 8, 7]),
      (1,  ARRAY[100, 0, 3])
  ) AS log (pop, metric)
  CROSS JOIN UNNEST(metric) WITH ORDINALITY AS t (m, idx)
  GROUP BY pop, idx
)