Query with object inside other objects

SQL++
11

SELECT RAW { a.app_uuid:ag}
FROM 1 AS d
UNNEST apps AS a
GROUP BY a.app_uuid
LETTEING ag = ARRAY_AGG({a.user_rating_avg, a.user_rating_count, a.rank})

Each app_uid gives as separate object. If u need all of them into one or split 50 each let me know

If you really don’y want to split then use this. Check keyspaces.

SELECT RAW { at.app_uuid:ag}
FROM tracker AS ar USE KEYS ["app-rank_top-free_us_1619618400",
                             "app-rank_top-paid_dz_1619618400",
                             "app-rank_top-free_ao_1619618400",
                             "app-rank_top-free_ai_1619618400"]
JOIN tracker AS am ON KEYS (ARRAY "app:a2t:" || v FOR v IN OBJECT_NAMES(ar.chart_apps) END)
JOIN tracker AS at ON KEYS "meta:" || am.app_uuid || ":" || ar.country_code
WHERE ar.type = "app-rank" AND am.type = "app-mapping" AND at.type = "app-tracker")
GROUP BY at.app_uuid
LETTEING ag = ARRAY_AGG({at.user_rating_avg, at.user_rating_count, "rank":ar.chart_apps.[am.app_id]});
1 Like