Advanced Operations for MongoDB (aggregation framework)

Group BY query do not use the Java drive with the group by, to use the 2.2 version of the aggregate aggregation framework, after the test speed of one times faster

Reference

Official website: http://docs.mongodb.org/manual/reference/sql-aggregation-comparison/
Example: http://www.yeetrack.com/?p=649

Before viewing the example, please look at the 2 reference documents, especially the official website

Example

[Java]View Plaincopy

2. First, $match filters out where conditions
4. Basicdbobject[] Array = {
6. New Basicdbobject ("Starttimelong", new Basicdbobject ("$gte", BeginTime)),
8. New Basicdbobject ("Starttimelong", new Basicdbobject ("$lt", EndTime)};
12. Basicdbobject cond = new Basicdbobject ();
14. Cond.put ("$and", array);
16. DBObject match = new Basicdbobject ("$match", cond);
20. Use $project to assemble the data required by the group, including OptCode columns, processtime columns
22. DBObject fields = new Basicdbobject ("OptCode", 1); //Interface
24. Fields.put ("Processtime", 1); Time consuming
26. Fields.put ("Provincecode", 1); Provinces
28. Fields.put ("Channelsubcode", 1); Channel
30. Fields.put ("Platformcode", 1); Platform
34. DBObject project = new Basicdbobject ("$project", fields);
38. Grouping with $group
40. DBObject _group = new Basicdbobject ("Provincecode", "$provinceCode");
42. _group.put ("Channelsubcode", "$channelSubCode");
44. _group.put ("Platformcode", "$platFormCode");
46. _group.put ("OptCode", "$optCode");
50. DBObject groupfields = new Basicdbobject ("_id", _group);
52. Total
54. Groupfields.put ("Count", new Basicdbobject ("$sum", 1));
56. //Sum
58. Groupfields.put ("processtime_sum", new Basicdbobject ("$sum","$processTime"));
60. DBObject Group = new Basicdbobject ("$group", groupfields);
62. Aggregationoutput output = Mongodbutil.getloginfocollection (). Aggregate (match, project, group);

Advanced Operations for MongoDB (aggregation framework)