I’m trying to output one single array merging two arrays from different documents and i can’t figure out how to do it.
Below is an example of what i’m trying to achieve:
Select all followers and followings users to a single array with the possibility to apply LIMIT and OFFSETS.
SELECT ARRAY_SORT(ARRAY_CONCAT(fs.followers,fi.followings)[0:3]) AS connections
FROM default AS fs
JOIN default AS fi ON KEYS (SPLIT(META(fs).id,"::follow")[0] || "::followings")
WHERE fs.followers IS NOT MISSING