[SERVER-24766] implement basic view functionality Created: 23/Jun/16  Updated: 03/May/17  Resolved: 22/Jul/16

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: None
Fix Version/s: 3.3.11

Type: Improvement Priority: Major - P3
Reporter: Geert Bosch Assignee: Kyle Suarez
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Documented
is documented by DOCS-8628 3.4 Rel Notes: Views Closed
is documented by DOCS-9437 Docs for SERVER-24766: implement basi... Closed
Related
is related to SERVER-25235 Views should drop 'singleBatch' if 'l... Closed
Backwards Compatibility: Major Change
Sprint: Integration 17 (07/15/16), Integration 18 (08/05/16)
Participants:

 Description   

Find/aggregate/distinct/count on views work on standalone mongod.
View definitions are persisted. For now, enable through server parameter, off by default.



 Comments   
Comment by Asya Kamsky [ 25/Jul/16 ]

As it currently stands, drivers cannot perform a find_one() on a view

This includes mongo shell.

Comment by Kyle Suarez [ 22/Jul/16 ]

The aggregate, find, count and distinct commands all work with views, so I'm going to mark this ticket as resolved.

As it currently stands, drivers cannot perform a find_one() on a view because the aggregate command does not support the singleBatch option. However, we'll address this in SERVER-25235; I'm going to mark "Driver Changes" as "Not Needed".

Comment by Githook User [ 22/Jul/16 ]

Author:

{u'username': u'ksuarz', u'name': u'Kyle Suarez', u'email': u'kyle.suarez@mongodb.com'}

Message: Revert "SERVER-24766 don't force a move in ViewResponseFormatter constructor"

This reverts commit 3b3c14bb60b365cde5caf68a2982fd9f6481cede.
Branch: master
https://github.com/mongodb/mongo/commit/b377f0ad4daa65bd0d695615f3f552870e87f191

Comment by Githook User [ 22/Jul/16 ]

Author:

{u'username': u'ksuarz', u'name': u'Kyle Suarez', u'email': u'kyle.suarez@mongodb.com'}

Message: SERVER-24766 don't force a move in ViewResponseFormatter constructor
Branch: master
https://github.com/mongodb/mongo/commit/3b3c14bb60b365cde5caf68a2982fd9f6481cede

Comment by Githook User [ 21/Jul/16 ]

Author:

{u'username': u'ksuarz', u'name': u'Kyle Suarez', u'email': u'kyle.suarez@mongodb.com'}

Message: SERVER-24766 views support for count and distinct

Adds a new class, ViewResponseFormatter, for transforming aggregation responses
into responses for other commands with a dissimilar format (i.e. count and
distinct).
Branch: master
https://github.com/mongodb/mongo/commit/6dfeb2606b11765f25c08478919f42cf01c68076

Comment by Githook User [ 19/Jul/16 ]

Author:

{u'username': u'ksuarz', u'name': u'Kyle Suarez', u'email': u'kyle.suarez@mongodb.com'}

Message: SERVER-24766 find command support for views
Branch: master
https://github.com/mongodb/mongo/commit/cef83c2fddc2d8cfffa76d3e8680fc6c069e75f3

Comment by Githook User [ 14/Jul/16 ]

Author:

{u'username': u'ksuarz', u'name': u'Kyle Suarez', u'email': u'kyle.suarez@mongodb.com'}

Message: SERVER-24766 aggregation support for views

Users can now run the aggregate command on a view, which will resolve the view
to the appropriate collection and run a modified aggregation.
Branch: master
https://github.com/mongodb/mongo/commit/cd91000e5fad86b74afcc550fbd147bac14700f0

Comment by Githook User [ 14/Jul/16 ]

Author:

{u'username': u'GeertBosch', u'name': u'Geert Bosch', u'email': u'geert@mongodb.com'}

Message: SERVER-24766: Add shell helper for createView
Branch: master
https://github.com/mongodb/mongo/commit/5f9cc132e0f6334895c083734a5d8124c8e8c631

Comment by Githook User [ 13/Jul/16 ]

Author:

{u'username': u'GeertBosch', u'name': u'Geert Bosch', u'email': u'geert@mongodb.com'}

Message: SERVER-24766 Rename error code 15999 to InvalidPipelineOperator
Branch: master
https://github.com/mongodb/mongo/commit/b62dcab903faa4c02dc1404fac87a982c52a7725

Comment by Kyle Suarez [ 11/Jul/16 ]

We need to review slowMs logging, profiling, and db.currentOp() output for when a query against a view is in progress. This will help with the general debugging of views; simply logging things at higher log levels is infeasible in production environments.

Comment by Githook User [ 07/Jul/16 ]

Author:

{u'username': u'ksuarz', u'name': u'Kyle Suarez', u'email': u'kyle.suarez@mongodb.com'}

Message: SERVER-24766 implement basic views library

Adds the basic infrastructure for read-only non-materialized views, as well as
the ability to create them (but not use them).

Views are disabled by default unless mongod is given the setParameter
enableViews=1.
Branch: master
https://github.com/mongodb/mongo/commit/e39c46b27f4ae58f96b685dd625b0165761fee0d

Generated at Thu Feb 08 04:07:22 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.