MongoDB aggregation $out step: store data in another database -
i'm building new big data project , using mongodb operational database. use pentaho kettle run etl processes , cleans de data.
in step of etl make mongodb aggregation pipeline next operators in order:
{$unwind: '$metrics'}, {$match:{'metrics.event.name': 'hover', 'observationtime':{ $gte:{ $date:"${data}" } } } }, { $project : { '_id': 0, 'remotelocation':1, "remoteip":1, "language" : 1, "observationtime" : 1, "device" : 1, "session_id" : 1, "user_id" : 1, "metrics" : 1, } }, { $out: "hover_tmp"}
my problem query executed on replica database, cannot write there , that's $out
in final step.
a posible solution specify collection of non-replica mongodb database.
is posible ? find other solution?
Comments
Post a Comment