How should I make the following mongoDB query?

Vote count:

0

Suppose I have the following MongoDB index:

• Day (1-365)


• Hour (0-23)


• Second (0-3599)

How should I form a mongoDB query that extract data with the following range:

min: {Day: 1, Hour: 10, Second: 2400}
max: {Day: 1, Hour: 12, Second: 1200}

I want manual examine the data because I got an chunkTooBig error as described here

If the range of data is:

min: {Day: 1, Hour: 10, Second: 1200}
max: {Day: 1, Hour: 10, Second: 2400}

The I can easily form a query by:

db.coll.find({Day:1, Hour:10, Second:{$gte:1200, $lt:2400}})

I think I'm probably missing something obvious here, can someone shed some light on me? Thank you!

asked 1 min ago

user2829759

16

How should I make the following mongoDB query?