db.runCommand(
{ mapreduce : <span><span><<span>collection</span>></span>,
map : <span><<span>mapfunction</span>></span>,
reduce : <span><<span>reducefunction</span>></span>
[, query : <span><<span>query</span><span>filter</span><span>object</span>></span>]
[, sort : <span><<span>sort</span><span>the</span><span>query.</span><span>useful</span><span>for</span><span>optimization</span>></span>]
[, limit : <span><<span>number</span><span>of</span><span>objects</span><span>to</span><span>return</span><span>from</span><span>collection</span>></span>]
[, out : <span><<span>output-collection</span><span>name</span>></span>]
[, keeptemp: <span><<span>true|false</span>></span>]
[, finalize : <span><<span>finalizefunction</span>></span>]
[, scope : <span><<span>object</span><span>where</span><span>fields</span><span>go</span><span>into</span><span>javascript</span><span>global</span><span>scope</span> ></span>]
[, verbose : true]
}
);</span>参数说明:
mapreduce:要操作的目标集合
map:映射函数(生成键值对序列,作为Reduce函数的参数)
reduce:统计函数
query:目标记录过滤
立即学习“PHP免费学习笔记(深入)”;
sort:对目标记录排序
limit:限制目标记录数量
out:统计结果存放集合(如果不指定则使用临时集合,在客户端断开后自动删除)
keeptemp:是否保留临时集合
finalize:最终处理函数(对reduce返回结果执行最终整理后存入结果集合)
scope:向map、reduce、finalize导入外部变量
verbose:显示详细的时间统计信息
{
"<span>_id</span>": <span>ObjectId(<span>"50ccb3f91e937e2927000004"</span>)</span>,
"<span>feed_type</span>": <span><span>1</span></span>,
"<span>to_user</span>": <span><span>234</span></span>,
"<span>time_line</span>": <span><span>"2012-12-16 01:26:00"</span>
}</span>{
"<span>_id</span>": <span>ObjectId(<span>"50ccb3ef1e937e0727000004"</span>)</span>,
"<span>feed_type</span>": <span><span>8</span></span>,
"<span>to_user</span>": <span><span>123</span></span>,
"<span>time_line</span>": <span><span>"2012-12-16 01:26:00"</span>
}</span>{
"<span>_id</span>": <span>ObjectId(<span>"50ccb3e31e937e0a27000003"</span>)</span>,
"<span>feed_type</span>": <span><span>1</span></span>,
"<span>to_user</span>": <span><span>123</span></span>,
"<span>time_line</span>": <span><span>"2012-12-16 01:26:00"</span>
}</span>{
"<span>_id</span>": <span>ObjectId(<span>"50ccb3d31e937e0927000001"</span>)</span>,
"<span>feed_type</span>": <span><span>1</span></span>,
"<span>to_user</span>": <span><span>123</span></span>,
"<span>time_line</span>": <span><span>"2012-12-16 01:26:00"</span>
}</span>| feed_type | to_user | cout |
| 1 | 234 | 1 |
| 8 | 123 | 1 |
| 1 | 123 | 2 |
<span>//编写map函数</span><span>$map</span> = <span>'
function() {
<span></span> var key = {to_user:this.to_user,feed_type:this.feed_type};
<span></span> var value = {count:1};
<span></span> emit(key,value);
} '</span>;
<span>//reduce 函数</span><span>$reduce</span> = <span>'
function(key, values) {
var ret = {count:0};
<span></span> for(var i in values) {
<span></span> ret.count += 1;
<span></span> }
<span></span> return ret;
}'</span>;
<span>//查询条件</span><span>$query</span> = <span>null</span>; <span>//本实例中没有查询条件,设置为null</span><span>$mongo</span> = <span>new</span> Mongo(<span>'mongodb://root:root@127.0.0.1: 28017/'</span>); <span>//链接mongodb,账号和密码为root,root</span><span>$instance</span> = <span>$mongo</span>->selectDB(<span>"testdb"</span>);
<span>//执行此命令后,会创建feed_temp_res的临时集合,并将统计后的数据放在该集合中</span><span>$cmd</span> = <span>$instance</span>->command(<span>array</span>(
<span></span><span></span><span>'mapreduce'</span> => <span>'feed'</span>,
<span></span><span></span><span>'map'</span> => <span>$map</span>,
<span></span><span></span><span>'reduce'</span> => <span>$reduce</span>,
<span></span><span></span><span>'query'</span> => <span>$query</span>,
<span></span><span></span><span>'out'</span> => <span>'feed_temp_res'</span>
));
<span>//查询临时集合中的统计数据,验证统计结果是否和预期结果一致</span><span>$cursor</span> = <span>$instance</span>->selectCollection(<span>'feed_temp_res'</span>)->find();
<span>$result</span> = <span>array</span>();
<span>try</span> {
<span></span><span>while</span> (<span>$cursor</span>->hasNext())
<span></span>{
<span></span><span></span><span>$result</span>[] = <span>$cursor</span>->getNext();
<span></span>}
}
<span>catch</span> (MongoConnectionException <span>$e</span>)
{
<span></span><span>echo</span><span>$e</span>->getMessage();
}
<span>catch</span> (MongoCursorTimeoutException <span>$e</span>)
{
<span></span><span>echo</span><span>$e</span>->getMessage();
}
<span>catch</span>(<span>Exception</span><span>$e</span>){
<span></span><span>echo</span><span>$e</span>->getMessage();
}
<span>//test</span>
var_dump(<span>$result</span>);{
"<span>_id</span>": <span>{
"<span>to_user</span>": <span><span>234</span></span>,
"<span>feed_type</span>": <span><span>1</span> }</span></span>,
"<span>value</span>": <span>{
"<span>count</span>": <span><span>1</span> }</span>}</span>{
"<span>_id</span>": <span>{
"<span>to_user</span>": <span><span>123</span></span>,
"<span>feed_type</span>": <span><span>8</span> }</span></span>,
"<span>value</span>": <span>{
"<span>count</span>": <span><span>1</span> }</span>}</span>{
"<span>_id</span>": <span>{
"<span>to_user</span>": <span><span>123</span></span>,
"<span>feed_type</span>": <span><span>1</span> }</span></span>,
"<span>value</span>": <span>{
"<span>count</span>": <span><span>2</span> }</span>}</span>/<span>**</span>
* mapReduce分组
*
* <span>@param</span> string <span>$table_name</span> 表名(要操作的目标集合名)
* <span>@param</span> string <span>$map</span> 映射函数(生成键值对序列,作为 reduce 函数参数)
* <span>@param</span> string <span>$reduce</span> 统计处理函数
* <span>@param</span> array <span>$query</span> 过滤条件 如:array(<span>'uid'</span>=><span>123</span>)
* <span>@param</span> array <span>$sort</span> 排序
* <span>@param</span> number <span>$limit</span> 限制的目标记录数
* <span>@param</span> string <span>$out</span> 统计结果存放集合 (不指定则使用tmp_mr_res<span>_</span><span>$table_name</span>, <span>1.8</span>以上版本需指定)
* <span>@param</span> bool <span>$keeptemp</span> 是否保留临时集合
* <span>@param</span> string <span>$finalize</span> 最终处理函数 (对reduce返回结果进行最终整理后存入结果集合)
* <span>@param</span> string <span>$scope</span> 向 <span>map</span>、reduce、finalize 导入外部js变量
* <span>@param</span> bool <span>$jsMode</span> 是否减少执行过程中BSON和JS的转换,默认true(注:false时 BSON-->JS-->map-->BSON-->JS-->reduce-->BSON,可处理非常大的mapreduce,<span>//true</span>时BSON-->js-->map-->reduce-->BSON)
* <span>@param</span> bool <span>$verbose</span> 是否产生更加详细的服务器日志
* <span>@param</span> bool <span>$returnresult</span> 是否返回新的结果集
* <span>@param</span> array &<span>$cmdresult</span> 返回mp命令执行结果 array(<span>"errmsg"</span>=><span>""</span>,<span>"code"</span>=><span>13606</span>,<span>"ok"</span>=><span>0</span>) ok=<span>1</span>表示执行命令成功
* <span>@return</span><span>*/</span>
function mapReduce(<span>$table_name</span>,<span>$map</span>,<span>$reduce</span>,<span>$query</span>=null,<span>$sort</span>=null,<span>$limit</span>=<span>0</span>,<span>$out</span>=<span>''</span>,<span>$keeptemp</span>=true,<span>$finalize</span>=null,<span>$scope</span>=null,<span>$jsMode</span>=true,<span>$verbose</span>=true,<span>$returnresult</span>=true,&<span>$cmdresult</span>){
<span>if</span>(empty(<span>$table_name</span>) || empty(<span>$map</span>) || empty(<span>$reduce</span>)){
<span>return</span> null;
}
<span>$map</span> = new MongoCode(<span>$map</span>);
<span>$reduce</span> = new MongoCode(<span>$reduce</span>);
<span>if</span>(empty(<span>$out</span>)){
<span>$out</span> = <span>'tmp_mr_res_'</span>.<span>$table_name</span>;
}
<span>$cmd</span> = array(
<span>'mapreduce'</span> => <span>$table_name</span>,
<span>'map'</span> => <span>$map</span>,
<span>'reduce'</span> => <span>$reduce</span>,
<span>'out'</span> =><span>$out</span>
);
<span>if</span>(!empty(<span>$query</span>) && is_array(<span>$query</span>)){
array_push(<span>$cmd</span>, array(<span>'query'</span>=><span>$query</span>));
}
<span>if</span>(!empty(<span>$sort</span>) && is_array(<span>$sort</span>)){
array_push(<span>$cmd</span>, array(<span>'sort'</span>=><span>$query</span>));
}
<span>if</span>(!empty(<span>$limit</span>) && is_int(<span>$limit</span>) && <span>$limit</span>><span>0</span>){
array_push(<span>$cmd</span>, array(<span>'limit'</span>=><span>$limit</span>));
}
<span>if</span>(!empty(<span>$keeptemp</span>) && is_bool(<span>$keeptemp</span>)){
array_push(<span>$cmd</span>, array(<span>'keeptemp'</span>=><span>$keeptemp</span>));
}
<span>if</span>(!empty(<span>$finalize</span>)){
<span>$finalize</span> = new Mongocode(<span>$finalize</span>);
array_push(<span>$cmd</span>, array(<span>'finalize'</span>=><span>$finalize</span>));
}
<span>if</span>(!empty(<span>$scope</span>)){
array_push(<span>$cmd</span>, array(<span>'scope'</span>=><span>$scope</span>));
}
<span>if</span>(!empty(<span>$jsMode</span>) && is_bool(<span>$jsMode</span>)){
array_push(<span>$cmd</span>, array(<span>'jsMode'</span>=><span>$jsMode</span>));
}
<span>if</span>(!empty(<span>$verbose</span>) && is_bool(<span>$verbose</span>)){
array_push(<span>$cmd</span>, array(<span>'verbose'</span>=><span>$verbose</span>));
}
<span>$dbname</span> = <span>$this</span>->curr_db_name;
<span>$cmdresult</span> = <span>$this</span>->mongo-><span>$dbname</span>->command(<span>$cmd</span>);
<span>if</span>(<span>$returnresult</span>){
<span>if</span>(<span>$cmdresult</span> && <span>$cmdresult</span>[<span>'ok'</span>]==<span>1</span>){
<span>$result</span> = <span>$this</span>->find(<span>$out</span>, array());
}
}
<span>if</span>(<span>$keeptemp</span>==false){
<span>//</span>删除集合
<span>$this</span>->mongo-><span>$dbname</span>->dropCollection(<span>$out</span>);
}
<span>return</span><span>$result</span>;
}以上就介绍了mongodb的mapreduce用法及php示例代码,包括了方面的内容,希望对PHP教程有兴趣的朋友有所帮助。
PHP怎么学习?PHP怎么入门?PHP在哪学?PHP怎么学才快?不用担心,这里为大家提供了PHP速学教程(入门到精通),有需要的小伙伴保存下载就能学习啦!
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号