suppose that I have different customers, anyone that send me an different json structure i.e.:
customer_1: {'name': ..., 'suame': ...}
customer_2: {'name': ..., 'address': ..., 'amount': ...}
customer_3: {'type': ..., 'amount': ..., 'color': ..., 'light': ...}
[...]
Actually I use MongoDB to store and work with this data, but for some reason I need to migrate to Cassandra. What is the best practices to store this data?
Option 1: I create an column family / table for any customer so any customer has its table and data structure
Option 2: I store all in an table, and every time I have an new customer (with an own json) I make an alter table to create new column?
Option 3: I store the json in one table, as map type, but in this way I caot work with the single value