[SERVER-6025] Similar mysql syntax "INSERT ... SELECT ..." for sharded collection. Created: 07/Jun/12 Updated: 06/Dec/22 Resolved: 28/Aug/18 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | Performance, Querying, Sharding, Write Ops |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Minor - P4 |
| Reporter: | Pavel Chertorogov | Assignee: | Backlog - Query Team (Inactive) |
| Resolution: | Duplicate | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Linux, Mongo 2.0.6, 3 shards (each in replica set with 2 machines and 1 arbiter) |
||
| Issue Links: |
|
||||||||||||||||||||
| Assigned Teams: |
Query
|
||||||||||||||||||||
| Participants: | |||||||||||||||||||||
| Description |
|
I can not find similar mysql syntax "INSERT ... SELECT ..." in mongo for sharded collection. db.eval() - does not work on sharded collection Use case: , |
| Comments |
| Comment by Kyle Suarez [ 28/Aug/18 ] |
|
Hi all, We've completed work on I'm going to close this ticket as a duplicate of Regards, |
| Comment by Asya Kamsky [ 22/Feb/18 ] |
|
This would be addressed by aggregation $out option once it's able to append to existing collection (whether that collection is sharded or unsharded).
|
| Comment by Pavel Chertorogov [ 08/Jun/12 ] |
|
Detailed description of my task, for which I need mysql syntax Actually full document from SOURCE collection looks like this: ,
} Data to this collection writes from 3 "front-end" servers (actually One of type of report is statistics for every site by unique host, ip So most preferable way to do this report (from many others) is , Of course I don't want write this collection from "front-end" servers. So my decision is write raw data from button to one collection. And |