search

Tokutek / mongo

TokuMX is a high-performance, concurrent, compressing, drop-in replacement engine for MongoDB | Issue tracker: https://tokutek.atlassian.net/browse/MX/ |
http://www.tokutek.com/products/tokumx-for-mongodb/
703 stars 97 forks source link

create collection as find() #1205

Closed kgorman closed 10 years ago

kgorman commented 10 years ago

In the RDBS world, it's very common to create a table from a select statement. All serverside.

CREATE TABLE myrollup AS SELECT * FROM foo;

It would be super handy to have an equivalent command in TokuMX. For instance:

db.createCollection(myrollup, {query:"db.mybigcol.find()"});
leifwalsh commented 10 years ago

Please use our jira tracker, we've deprecated github issues.

You can do this with db.cloneCollection() today, or once we merge 2.6 features you'll be able to use the $out aggregation operator.