New column

2019-08-18 Thread Rahul Reddy
Hello, We have a table and want to add column and select based on existing entire primary key plus new column using allow filtering. Since my where clause has all the primary key + new column does the allow filtering scan only the partions which are listed or does it has to scan whole table? What

Re: New column

2019-08-18 Thread Stefan Miklosovic
You have to basically create new table and include that column either as part of primary key or you make it a clustering column. Avoid using allow filtering, it should not be used in production nor any serious app. On Sun, 18 Aug 2019 at 21:57, Rahul Reddy wrote: > > Hello, > > We have a table an

Re: New column

2019-08-18 Thread Jon Haddad
If you're giving the partition key you won't scan the whole table. The overhead will depend on the size or the partition. Would be an interesting workload for our tlp-stress tool, I'll code something up for the next release. On Sun, Aug 18, 2019, 12:58 PM Rahul Reddy wrote: > Hello, > > We have

Unsubscribe

2019-08-18 Thread Rob Schoening
- To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org