medium post

athena.sql

/* Assume the table is called order on Athena */

SELECT
  "item category",
  reduce(kv1['Asia Pacific'], 0.0, (s, x) ->  s + x, s-> s) AS "Asia Pacific",
  reduce(kv1['North America'], 0.0, (s, x) ->  s + x, s-> s) AS "North America"
FROM (
 SELECT 
  "item category",
  multimap_agg("region", amount) kv1
  FROM order 
  GROUP BY "item category"
)