Multi-column range scans

2014-07-13 Thread Matthew Allen
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

Re: keyspace with hundreds of columnfamilies

2014-07-13 Thread Jack Krupansky
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