- Section 1: Basics
- 2: User-friendly language
- 3: Documents, not rows
- 4: Pattern matching with LIKE
- 5: Matching elements in nested arrays with ANY
- 6: Combining multiple conditions with AND
- 7: Querying primary keys
- 8: Quick review
- 9: Pagination with LIMIT and OFFSET
- 10: Filtering grouped data with HAVING
- 11. Review
- 12. Section 2: Joins
- 13. Joins
- 14. Joins
- 15. Exercise
- 16. Exercise
- 17. NEST
- 18. Chaining JOINs
- 19. Example
- 20. Array Comprehensions
- 21. Section 3: DML Statements
- 22. Nest
- 23. Nest
- 24. UNNEST
- 25. Filtering on nested data
- 26. Subquery
- 27. Subquery
- 28. UPDATE
- 29. Case Study I. E-Commerce
- 30. Shopper - Browsing products from page to page
- 31. Shopper - Listing product categories
- 32. Shopper - Browsing and searching for a product
- 33. Shopper - Listing products in a category
- 34. Shopper - Finding the most popular products in a category
- 35. Shopper - Browsing products and sorting results
- 36. Shopper - Shopping at a one-day sale
- 37. Shopper - Listing the top 10 best selling products
- 38. Shopper - Listing the highest rated products
- 39. Merchant - Preparing a purchase order
- 40. Merchant - Finding the most valued shoppers
- 41. Merchant - Reporting customers by region
- 42. Merchant - Reporting the active monthly customers
- 43. Merchant - Identifying non-performing products
- 44. Merchant - Generating the month-over-month sales report
- 45. Merchant - Big ticket orders
- 46. Case Study II . Social Game
- 47. Assembling and loading user profiles
- 48. Listing messages sent by a user
- 49. Generating scoreboards
NEST performs a join across two buckets. But instead of producing an
object for each combination of left and right hand inputs, NEST
produces a single object for each left hand input, while the
corresponding right hand inputs are collected into an array and nested
as a single array-valued field in the result object.
The query on the right nests a user's orders in the result. Try replacing NEST with JOIN in the query to see the difference between these two operators.
Similar to JOIN, NEST also supports LEFT [ OUTER ] NEST.
The query on the right nests a user's orders in the result. Try replacing NEST with JOIN in the query to see the difference between these two operators.
Similar to JOIN, NEST also supports LEFT [ OUTER ] NEST.
To run this example, click the button in the top right corner of the code editor.