MongoDb Java with query : Select ....From ... Where field in (Select ......)

Question

My database has 2 collections : Cell(_id, segment_id, cell_id) and SegmentSpeed(_id, segment_id, speed) And I want to perform the query below (sql format) in Java :

"Select * From SegmentSpeed Where segment_id in (Select segment_id From Cell Where cell_id>5)"

That is Mysql query, and the problem is I want to execute this query with MongoDb format in JAVA.

Thanks !

bsd · Accepted Answer · 2013-09-10 16:50:40Z

1

MongoDB does not support joins.

You may have to resort to some clunky and inefficient map-reduce operations if you are unable to change your schema.

What you can do is embed the whole SegmentSpeed inside a document of Cell.

answered Sep 10, 2013 at 16:50

bsd

2,7371 gold badge19 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDb Java with query : Select ....From ... Where field in (Select ......)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related