Merging all arrays in N1QL via set intersection?

SQL++
1

Suppose I have this query:

select tags from myBucket;

and it returns:

   {
    "tags": [
      "a",
      "b"
    ]
  },
  {
    "tags": [
      "b",
      "c"
    ]
  },

Is there a query that would return one row, consisting of:

"tags": [ 
  "a",
  "b",
  "c"
]
2

Yes. See GROUP BY, ARRAY_AGG(), ARRAY_FLATTEN(), and ARRAY_INTERSECT().