1. which hadoop version support both mongodb and rdbs?
I believe that all versions of Hadoop supporting MongoDB also support RDBMS (the RDBMS implementations predate MongoDB).
For supported versions of Hadoop to use with MongoDB, see: Building the Adapter. Check the version information as some Hadoop versions do not support the Streaming Connector (i.e. if you want to write your jobs in non-JVM languages such as Python).
2. Is it possible to use multiple collections as input...?
If possible, how we can do that?
MongoDB Hadoop Connector v1.0.0 does not support multiple collections as input, but there are a few folks in the community working on this (see: Feature/multiple inputs).
3. I tried mongodb query in hadoop,It's working fine. But when i defined
sort or limit... It is not working properly..even it's not fetching data
from mongodb...
Can you provide an example of how/where you provided these options? Are you referring to the mongo.input.sort
and mongo.input.limit
properties?
You may want to try enabling the Database Profiler in MongoDB to confirm the queries are being sent:
db.setProfilingLevel(2)