[ 
https://issues.apache.org/jira/browse/CASSANDRA-16733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17361857#comment-17361857
 ] 

Benjamin Lerer commented on CASSANDRA-16733:
--------------------------------------------

|| Branch || CI ||
|[3.0|https://github.com/apache/cassandra/pull/1061]|[J8|https://app.circleci.com/pipelines/github/blerer/cassandra/147/workflows/69eda7e1-5e16-487e-9395-673ee0cfa1ca]|
|[3.11|https://github.com/apache/cassandra/pull/1062]|[J8|https://app.circleci.com/pipelines/github/blerer/cassandra/146/workflows/1e2e31e1-d46f-4fcd-b9f7-d7829f5c9b3b]|
|[4.0|https://github.com/apache/cassandra/pull/1063]|[J8|https://app.circleci.com/pipelines/github/blerer/cassandra/148/workflows/429e34ca-0ad1-4bda-aacc-bbc3a96c7c0d],
 
[J11|https://app.circleci.com/pipelines/github/blerer/cassandra/148/workflows/a3d47204-e2b2-4680-8550-4d81857fb3dd]|

> Allow operators to disable 'ALTER ... DROP COMPACT STORAGE' statements
> ----------------------------------------------------------------------
>
>                 Key: CASSANDRA-16733
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-16733
>             Project: Cassandra
>          Issue Type: Bug
>          Components: Legacy/CQL
>            Reporter: Benjamin Lerer
>            Assignee: Benjamin Lerer
>            Priority: Normal
>             Fix For: 4.0-rc2, 3.0.x, 3.11.x
>
>
> {{ALTER ... DROP COMPACT STORAGE}} statements have not been extensively 
> tested and suffer from several issues like:
> * As COMPACT tables did not have primary key liveness there empty rows
> inserted AFTER the ALTER will be returned whereas the one inserted before
> the ALTER will not.
> * Also due to the lack of primary key liveness the amount of SSTables being
> read will increase resulting in slower queries (CASSANDRA-16675)
> * After DROP COMPACT it becomes possible to ALTER the table in a way that
> makes all the row disappears
> * There is a loss of functionality around null clustering when dropping
> compact storage (CASSANDRA-16069)
> To avoid running into those issues this ticket will introduce a new flag that 
> allow operators to disable those statements on their clusters.
> see https://www.mail-archive.com/[email protected]/msg16789.html



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to