1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
|
// Test script from SERVER-1742
// MongoDB test script for mapreduce with geo query
// setup test collection
db.apples.drop();
db.apples.insert({"geo": {"lat": 32.68331909, "long": 69.41610718}, "apples": 5});
db.apples.insert({"geo": {"lat": 35.01860809, "long": 70.92027283}, "apples": 2});
db.apples.insert({"geo": {"lat": 31.11639023, "long": 64.19970703}, "apples": 11});
db.apples.insert({"geo": {"lat": 32.64500046, "long": 69.36251068}, "apples": 4});
db.apples.insert({"geo": {"lat": 33.23638916, "long": 69.81360626}, "apples": 9});
db.apples.ensureIndex({"geo": "2d"});
center = [32.68, 69.41];
radius = 10 / 111; // 10km; 1 arcdegree ~= 111km
geo_query = {
geo: {'$within': {'$center': [center, radius]}}
};
// geo query on collection works fine
res = db.apples.find(geo_query);
assert.eq(2, res.count());
// map function
m = function() {
emit(null, {"apples": this.apples});
};
// reduce function
r = function(key, values) {
var total = 0;
for (var i = 0; i < values.length; i++) {
total += values[i].apples;
}
return {
"apples": total
};
};
// mapreduce without geo query works fine
res = db.apples.mapReduce(m, r, {out: {inline: 1}});
printjson(res);
total = res.results[0];
assert.eq(31, total.value.apples);
// mapreduce with regular query works fine too
res = db.apples.mapReduce(m, r, {out: {inline: 1}, query: {apples: {'$lt': 9}}});
total = res.results[0];
assert.eq(11, total.value.apples);
// mapreduce with geo query gives error on mongodb version 1.6.2
// uncaught exception: map reduce failed: {
// "assertion" : "manual matcher config not allowed",
// "assertionCode" : 13285,
// "errmsg" : "db assertion failure",
// "ok" : 0 }
res = db.apples.mapReduce(m, r, {out: {inline: 1}, query: geo_query});
total = res.results[0];
assert.eq(9, total.value.apples);
|
