Re: New column

2019-08-22 Thread Rahul Reddy
Thank you jon On Thu, Aug 22, 2019, 1:27 PM Jon Haddad wrote: > Just to close the loop on this, I did a release of tlp-stress last night, > which now has this workload (AllowFiltering). You can grab a deb, rpm, > tarball or docker image. > > Docs are here: http://thelastpickle.com/tlp-stress/ >

Re: New column

2019-08-22 Thread Jon Haddad
Just to close the loop on this, I did a release of tlp-stress last night, which now has this workload (AllowFiltering). You can grab a deb, rpm, tarball or docker image. Docs are here: http://thelastpickle.com/tlp-stress/ Jon On Mon, Aug 19, 2019 at 2:21 PM Jon Haddad wrote: > It'll be about

Re: New column

2019-08-19 Thread Jon Haddad
It'll be about the same overhead as selecting the entire partition, since that's essentially what you're doing. I created a tlp-stress workload this morning but haven't merged it into master yet. I need to do a little cleanup and I might tweak it a little, but if you're feeling adventurous you ca

Re: New column

2019-08-19 Thread Rahul Reddy
Jon, If we expect non of our partition key to have more than 100 records and pass partition key in where clause we wouldnt see issues using new column and allow filtering? Can you please point me to any doc how allow filtering works. I was in assumption of it goes through all the partitions On

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

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 addition and Locking

2017-09-09 Thread Myrle Krantz
There's a tool in the early stages of development here: https://github.com/mifosio/cassandra/tree/develop/src/main/java/io/mifos/core/cassandra/core That is part of a mass of code which is currently under (slow) discussion to be added to the Apache Fineract project. ALV2 license. I wouldn't be

Re: New Column addition and Locking

2017-09-08 Thread Jeff Jirsa
CASSANDRA-13004 -- Jeff Jirsa > On Sep 8, 2017, at 7:33 AM, Deepak Panda wrote: > > Many Thanks Jeff for the answer and the relevant details. Can you > please share the bug#? > > Are there any opensource tools available for Cassandra which manage > schema changes for Cassandra? > >> On Fri,

Re: New Column addition and Locking

2017-09-08 Thread Deepak Panda
Many Thanks Jeff for the answer and the relevant details. Can you please share the bug#? Are there any opensource tools available for Cassandra which manage schema changes for Cassandra? On Fri, Sep 8, 2017 at 7:57 PM, Jeff Jirsa wrote: > There is no lock and it doesn't block existing reads or w

Re: New Column addition and Locking

2017-09-08 Thread Jeff Jirsa
There is no lock and it doesn't block existing reads or writes You're already on 3.11, but as a reminder for others there's a bug in 3.0 versions between (3.0.0 and 3.0.14) and (3.0 and 3.11.0) that can cause corruption when you add columns. It's fixed in both 3.11.0 and 3.0.14, so if you need