Hello,
I have a user object with nested objects such as "stores" (favorite shopping stores) inside which we have details such as the id of the store, the brand of the store, country of the store, etc.
I want to come with a query for 2 separate scenarios but have not been successful:
People who visit only Brand B in Country C1.
People who visit only store 1 for brand B in C1. (This should include people who go to brand d in store 2 but not those who go to brand B in store 2)
Your constraints aren't terribly clear, so I've reformulated the first one as: People who, in country C1, visit only Brand B and no other brands. It's OK for them to visit Brand B or any other brands in a different country.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.