Hi,
We have a roll-up table that as follows.
CREATE TABLE SKILL_COUNT (
skill text,
interval_id bigint,
skill_level int,
skill_count int,
PRIMARY KEY (skill, interval_id, skill_level));
Essentially,
skill = a names skill i.e. "Complaints"
interval_id = a rounded epoch time (15 minu
If your 1K tables might grow to 5 or 10K, then doesn’t that mean you would be
trying to add columns, later, after you’ve populated your data? If so, that
would argue for using one or more map columns, to accommodate the dynamic
addition of pseudo-columns.
Once again, look at your queries (as t