You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Deepak Panda <de...@gmail.com> on 2017/09/08 14:13:09 UTC

New Column addition and Locking

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-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org

Re: New Column addition and Locking

Posted by Jeff Jirsa <jj...@gmail.com>.
CASSANDRA-13004

-- 
Jeff Jirsa


> On Sep 8, 2017, at 7:33 AM, Deepak Panda <de...@gmail.com> 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 <jj...@gmail.com> 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 <de...@gmail.com> 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-unsubscribe@cassandra.apache.org
>>> For additional commands, e-mail: user-help@cassandra.apache.org
>>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
>> For additional commands, e-mail: user-help@cassandra.apache.org
>> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
> For additional commands, e-mail: user-help@cassandra.apache.org
> 

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

Re: New Column addition and Locking

Posted by Myrle Krantz <oj...@gmail.com>.
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 <de...@gmail.com> 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 <jj...@gmail.com> 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 <de...@gmail.com> 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-unsubscribe@cassandra.apache.org
>>> For additional commands, e-mail: user-help@cassandra.apache.org
>>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
>> For additional commands, e-mail: user-help@cassandra.apache.org
>> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
> For additional commands, e-mail: user-help@cassandra.apache.org
>

Re: New Column addition and Locking

Posted by Deepak Panda <de...@gmail.com>.
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 <jj...@gmail.com> 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 <de...@gmail.com> 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-unsubscribe@cassandra.apache.org
>> For additional commands, e-mail: user-help@cassandra.apache.org
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
> For additional commands, e-mail: user-help@cassandra.apache.org
>

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

Re: New Column addition and Locking

Posted by Jeff Jirsa <jj...@gmail.com>.
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 <de...@gmail.com> 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-unsubscribe@cassandra.apache.org
> For additional commands, e-mail: user-help@cassandra.apache.org
> 

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