Delete comment from: Julian Hyde on Streaming Data, Open Source OLAP. And stuff.

Julian Hyde said...

If the data is outside MongoDB, you could use optiq-csv, to which we recently added support for JSON files.

But within MongoDB, I suggest that you load each file into a different MongoDB collection in the same MongoDB database. From Optiq each MongoDB collection automatically appears as a SQL table with a column called _MAP. (In the example, that table is called "mongo_raw"."zips".) You can create views on those tables, similar to the "mongo"."zips" view in the example, or you can query the raw table.

Jul 7, 2014, 1:20:59 PM

Posted to Efficient SQL queries on MongoDB