Re: New Column addition and Locking

[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 sad if it landed at Cassandra instead. 

Regards,
Myrle 

Sent from my iPhone

> On 8. Sep 2017, at 16:33, 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, Sep 8, 2017 at 7:57 PM, Jeff Jirsa  wrote:
>> 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 to alter your table and you're on a 3.something version that isn't 
>> one of those, upgrade first.
>> 
>> --
>> Jeff Jirsa
>> 
>> 
>>> On Sep 8, 2017, at 7:13 AM, Deepak Panda  wrote:
>>> 
>>> Hi,
>>> 
>>> For Cassandra 3.11, when we add a new column is added to an existing
>>> table having huge number of rows and huge data manipulation going on
>>> will there be any issues?
>>> 
>>> Will the operations blocked till the column is added?
>>> 
>>> Is the table locked during column addition? If yes, what type of lock?
>>> 
>>> -
>>> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
>>> For additional commands, e-mail: user-h...@cassandra.apache.org
>>> 
>> 
>> -
>> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
>> For additional commands, e-mail: user-h...@cassandra.apache.org
>> 
> 
> -
> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
> For additional commands, e-mail: user-h...@cassandra.apache.org
> 

Re: New Column addition and Locking

[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, Sep 8, 2017 at 7:57 PM, Jeff Jirsa  wrote:
>> 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 to alter your table and you're on a 3.something version that isn't 
>> one of those, upgrade first.
>> 
>> --
>> Jeff Jirsa
>> 
>> 
>>> On Sep 8, 2017, at 7:13 AM, Deepak Panda  wrote:
>>> 
>>> Hi,
>>> 
>>> For Cassandra 3.11, when we add a new column is added to an existing
>>> table having huge number of rows and huge data manipulation going on
>>> will there be any issues?
>>> 
>>> Will the operations blocked till the column is added?
>>> 
>>> Is the table locked during column addition? If yes, what type of lock?
>>> 
>>> -
>>> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
>>> For additional commands, e-mail: user-h...@cassandra.apache.org
>>> 
>> 
>> -
>> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
>> For additional commands, e-mail: user-h...@cassandra.apache.org
>> 
> 
> -
> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
> For additional commands, e-mail: user-h...@cassandra.apache.org
> 

-
To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
For additional commands, e-mail: user-h...@cassandra.apache.org

Re: New Column addition and Locking

[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 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 to alter your table and you're on a 3.something version that isn't 
> one of those, upgrade first.
>
> --
> Jeff Jirsa
>
>
>> On Sep 8, 2017, at 7:13 AM, Deepak Panda  wrote:
>>
>> Hi,
>>
>> For Cassandra 3.11, when we add a new column is added to an existing
>> table having huge number of rows and huge data manipulation going on
>> will there be any issues?
>>
>> Will the operations blocked till the column is added?
>>
>> Is the table locked during column addition? If yes, what type of lock?
>>
>> -
>> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
>> For additional commands, e-mail: user-h...@cassandra.apache.org
>>
>
> -
> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
> For additional commands, e-mail: user-h...@cassandra.apache.org
>

-
To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
For additional commands, e-mail: user-h...@cassandra.apache.org

Re: New Column addition and Locking

[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 to alter your table and you're on a 3.something version that isn't one 
of those, upgrade first. 

-- 
Jeff Jirsa


> On Sep 8, 2017, at 7:13 AM, Deepak Panda  wrote:
> 
> Hi,
> 
> For Cassandra 3.11, when we add a new column is added to an existing
> table having huge number of rows and huge data manipulation going on
> will there be any issues?
> 
> Will the operations blocked till the column is added?
> 
> Is the table locked during column addition? If yes, what type of lock?
> 
> -
> To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
> For additional commands, e-mail: user-h...@cassandra.apache.org
> 

-
To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org
For additional commands, e-mail: user-h...@cassandra.apache.org