New answers tagged

0

If you know start _id and end _id then you can retrieve the bulk you inserted using query like this: db.yourCollection.find({_id:{$gt:ObjectId("56e13d5aed63a8477a7e2e78"), $lt: ObjectId("570f5a27b2d1a50996d3a0f0")}}) Replace the default mongodb ObjectIds with your _id fields. Also, if the _id you are using is default mongodb ObjectId then you can easily ...


0

Plan A: (Drawback: you might still have gaps.) Find all epoch values from the 4 tables using UNION DISTINCT. LEFT JOIN from that table to the other 4 tables. Plan B: (Drawback: I don't say how to do step 1.) Build a TEMPORARY table with every 5-min time for the next N months. LEFT JOIN ... Plan C: (Drawback: Step 1.) Upgrade to MariaDB. Use a ...



Top 50 recent answers are included