This article discusses a common mistake users make when preparing a cluster for an upgrade to DataStax Enterprise 6.0.
- DataStax Enterprise 5.0.11 and earlier
- DataStax Enterprise 5.1.5 and earlier
While attempting to remove Thrift-compatibility from a table, users encounter an error with the
DROP COMPACT STORAGE command. For example:
cqlsh> ALTER TABLE “HiveMetaStore”.sparkmetastore DROP COMPACT STORAGE; InvalidRequest: Error from server: code=2200 [Invalid query] \
message=“Cannot drop columns from a non-CQL3 table”
With the removal of Thrift in Apache Cassandra 4.0 (CASSANDRA-11115), support for COMPACT STORAGE was also removed. In order to prepare a cluster for an upgrade to DSE 6.0, legacy tables with Thrift-compatibility enabled need to be migrated with the
ALTER TABLE ... DROP COMPACT STORAGE command (CASSANDRA-10857).
DROP COMPACT STORAGE is only included in DSE 5.0.12+ and 5.1.6+ clusters (DSP-14839). Attempts to use the command on earlier versions of DSE will fail.
Clusters running earlier versions of DSE must be upgraded to at least the following versions before upgrading to DSE 6.0:
- for DSE 5.0 clusters, upgrade to DSE 5.0.12 or later
- for DSE 5.1 clusters, upgrade to DSE 5.1.6 or later
NOTE - It is not necessary to run
nodetool upgradesstables when performing a minor patch release (e.g. upgrading from 5.0.6 to 5.0.12, or 5.1.2 to 5.1.6) unless explicitly stated by the relevant Upgrade document for the release. If in doubt, run the
upgradesstables since it will be a "no-op" if the SSTables do not need to be rewritten.