Bringing together the Apache Cassandra experts from the community and DataStax.

Want to learn? Have a question? Want to share your expertise? You are in the right place!

Not sure where to begin? Getting Started

 

question

sunil281984 avatar image
sunil281984 asked Erick Ramirez answered

Is it necessary to DROP COMPACT STORAGE when upgrading off DSE 6.7.7?

During the upgrade from 6.7.7 to 6.7.16 to 6.8.23 so we need to migrate all tables from COMPACT STORAGE to CQL table format. Is it necessary in 6.x version because I think it is for 5.x versions . Please correct me and let me know to add this step for my upgrade document

upgrade
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

smadhavan avatar image
smadhavan answered smadhavan edited

@sunil281984, yes, Support for Thrift-compatible tables (COMPACT STORAGE) is dropped in 6.x (i.e 6.0.x, 6.7.x, 6.8.x doesn't support it). Before upgrading, migrate all non-system tables that have COMPACT STORAGE to CQL table format. DSE will not start if tables using COMPACT STORAGE are present and even in an edge case, if it does start, it will present other problems as it is not supported.

Considering your case, since you're already on 6.7.7, you wouldn't have thirft-compatible tables and it is better to validate your non-system tables and get rid of those per the upgrade prerequisite instructions here. If you still have questions or would require help with your upgrade situation, please submit a DataStax Support ticket and an engineer would be happy to go in depth & assist.

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.

Erick Ramirez avatar image
Erick Ramirez answered

Support for Thrift was deprecated all the way back to 2014 and was disabled in Apache Cassandra 2.2 (CASSANDRA-9319). The option DROP COMPACT STORAGE for the CQL command ALTER TABLE was added to DSE 5.0.12 and DSE 5.16 (DSP-14839) so operators can remove the Thrift format from the legacy tables.

This means that Thrift tables in DSE 4.8 clusters (or earlier) should have been converted by operators when they were upgraded to DSE 5.0 or 5.1, and only CQL tables should exist in DSE 6.x clusters.

Given that your cluster is DSE 6.7, you need to do this now regardless of whether you are upgrading or not. Cheers!

Share
10 |1000

Up to 8 attachments (including images) can be used with a maximum of 1.0 MiB each and 10.0 MiB total.