Since you understand this better, here is an overview of my problem:
Joining all my datasets in Spark and then loading a big dataset into MapD was slow/expensive, so I was thinking I could perform the joins on MapD instead. I was hoping to load my individual datasets (venues, events, coordinates) and then perform the joins on MapD, creating a (venues_events_coordinates) table.
I was doing this using CREATE VIEW AS, not knowing that it doesn’t save the actual data, it saves the formula. CREATE TABLE AS seems like a solution, but i have a question: when I upload new venues/events/coordinates data, will it update the resulting venues_events_coordinates table automatically?