In cassandra if i have table per query and i have multiple combinations of filter, do i create a table for each of them?
In cassandra if i have table per query and i have multiple combinations of filter, do i create a table for each of them? I am new to NoSQL and i was trying to get my head around how to model data correctly for an e-commerce site. Amazon has these filters for different type of products, for example if you search for laptops, there are filters like brand, processor, hard disk, graphics card, os and etc. So by what i understand, first the primary key will be partitioned by browse node id (i.e. laptop here), then we can have additional keys as sort key, but the problem is that if there are 6 filters there will be around 64 combinations that can be formed. I can select brand and processor, or maybe brand and graphics card, or maybe processor and graphics card, and this will be exponential with the number of filters, so i assume having a table for each possibility is not feasible. I also doubt that filtering after getting the whole partition data is possible, that would be too slow. So how s...