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



adampaul avatar image
adampaul asked ·

IllegalArgumentException: Found 2 incompatible versions of column

I created new keyspace "testks_21092020_adam" from backup of testks_23082020 used sstableloader.

now getting this in logs what can be caused?

java.lang.IllegalArgumentException: Found 2 incompatible versions of column employee_info in testks_21092020_adam.employee: one of type org.apache.cassandra.db.marshal.FrozenType(org.apache.cassandra.db.marshal.UserType(testks_23082020,6c6561645f696e666f,6964:org.apache.cassandra.db.marshal.UUIDType,6c6561645f75756964:org.apache.cassandra.db.marshal.UTF8Type,6c6561645f646973706c61795f6964:org.apache.cassandra.db.marshal.LongType,6c6561645f74797065:org.apache.cassandra.db.marshal.UTF8Type,6c6561645f636f6e746578745f74797065:org.apache.cassandra.db.marshal.UTF8Type,6c6561645f636f6e746578745f6964:org.apache.cassandra.db.marshal.UTF8Type,7961676e615f6c6561645f71756f74655f75756964:org.apache.cassandra.db.marshal.UTF8Type)) and one of type org.apache.cassandra.db.marshal.FrozenType(org.apache.cassandra.db.marshal.UserType(testks_21092020_adam,6c6561645f696e666f,6964:org.apache.cassandra.db.marshal.UUIDType,6c6561645f75756964:org.apache.cassandra.db.marshal.UTF8Type,6c6561645f646973706c61795f6964:org.apache.cassandra.db.marshal.LongType,6c6561645f74797065:org.apache.cassandra.db.marshal.UTF8Type,6c6561645f636f6e746578745f74797065:org.apache.cassandra.db.marshal.UTF8Type,6c6561645f636f6e746578745f6964:org.apache.cassandra.db.marshal.UTF8Type,7961676e615f6c6561645f71756f74655f75756964:org.apache.cassandra.db.marshal.UTF8Type)) (but both types are incompatible).

10 |1000 characters needed characters left characters exceeded

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

1 Answer

Erick Ramirez avatar image
Erick Ramirez answered ·

As the exception states, you are loading SSTables from a table which has a user-defined type (org.apache.cassandra.db.marshal.UserType) from one keyspace testks_23082020 to another testks_21092020_adam which is not compatible with the destination table since the UDT belongs to a different keyspace.

It is not possible to restore/load an SSTable with a UDT to another keyspace because a UDT belongs to a specific keyspace.

From the sstableloader document:

WARNING: DSE verifies that the contents of the SSTables match the schema of the tables you are loading. User-defined types (UDTs) are a part of the keyspace, so loading an SSTable with a UDT from a different keyspace is incompatible, and will be rejected. A table is only allowed to use UDTs that exist in the same keyspace as the table.


10 |1000 characters needed characters left characters exceeded

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