Although I don’t fully understand how this query works (are ORDER BY and LIMIT missing ?) , I do wander about its performance cost in real time.
Is the N1QL query being evaluated every call, based on millions of item in the bucket ?
Is the view being evaluated only offline ?
What if this query is called many times ?
COUNT(reviews) AS reviewCount,
ROUND(AVG(reviews.rating),1) AS AvgRating,
FROM reviews AS reviews
JOIN product AS product
ON KEYS reviews.productId
UNNEST product.categories AS category
Plus, according to N1QL roadmap, when is it scheduled to be released ?
Will it be available with the community server version as well at the same time ?