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
@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.
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!
7 People are following this question.
