Suppose in the killrvideo app I want to show all the movie theaters near to the user location, how would you model for such cases.
One way you could achieve this is by using a geo-hash. You can implement this using only a Cassandra based data model with no need for other workloads within DataStax Astra.
Check out this video from the personal blog of one of our DataStax folks -> He starts with talking about how to do this with DataStax enterprise, but at around 6:00 talks about how to do this with Astra.
This video comes from his blog. Notice the June 2020 post -> https://github.com/farrell0/DataStax-Developers-Notebook/blob/master/README.md. Notice the Application program code link. Download, untar it, and within you will find some *.cql files with the needed data model to support geo-hashing with a purely Cassandra workload.
BTW, I am making some assumptions at what I think you might want to do with the information you provided
" I want to show all the movie theaters near to the user location"
which is why I am suggesting a geo-hash since you can use it to handle various methods of creating search boxes/polygons to find theatre or whatever locations.
8 People are following this question.