Hi, I am trying to join data based on the latitude and longitude. I have reference data which has city information with their latitude and longitude.
I have a data source with user information with their latitude and longitude. I want to find the nearest city to the user's latitude and longitude. I had initially planned to use $near operator in mongo in the map function for every user but it does not scale well. Is there any other option? Can I join the data in two files without loading to mongo? Thanks Ankur