Hi
If we have several documents like:
users_doc:
id
name
address
country
job_id
…
job_doc:
id
name
skill
salary
…
with these conditions it can get data from both documents:
country ==US and salary > 200 and job==Teacher
RediSearch does not support joins. The possible option is to denormalise. In your users_docs you may add a field containing the job this user is doing. As Redis let’s you update a field in a hash, it is pretty easy to update a user by updating its jobs. RediSearch will be atomically updated.
If you can’t denormalise you may have a look at RedisGears. You will be able to run both queries and do the join manually.,