Re: Cassandra data model too many table

2018-02-18 Thread Jeff Jirsa
You’re basically looking to query and aggregate the data arbitrarily - you may have better luck using spark or solr pointing to a single backing table in Cassandra -- Jeff Jirsa > On Feb 18, 2018, at 3:38 AM, onmstester onmstester > wrote: > > I have a single

Re: Cassandra data model too many table

2018-02-18 Thread Rahul Singh
What’s the root cause of this many queries? Is this because of multi tenancy or multiple processes ? It’s possible to potentially logically group some of this data if you use collections / sets inside a column. That works if the data is of a similar structure of a similar query. It’s

Cassandra data model too many table

2018-02-18 Thread onmstester onmstester
I have a single structured row as input with rate of 10K per seconds. Each row has 20 columns. Some queries should be answered on these inputs. Because most of queries needs different where, group by or orderby, The final data model ended up like this: primary key for table of query1 :