tyuen_144153 avatar image
tyuen_144153 asked Erick Ramirez answered

Cannot load data for a table with CQL type duration with C* 3.11.5 sstableloader

I have a Cassandra table with the data type "duration". However, when I tried to use to sstableloader to restore the snapshot into another cluster with the duration data type, I'm getting cannot resolve user type.

The duration data type is a native type within Cassandra. I'm running Cassandra 3.11.3 community edition.

ERROR 17:38:10,726 Error parsing schema for table datakeyspace.retrylog: Cluster.getMetadata().getKeyspace("datakeyspace").getTable("retrylog") will be missing or incomplete
com.datastax.driver.core.exceptions.UnresolvedUserTypeException: Cannot resolve user type datakeyspace.duration
        at com.datastax.driver.core.DataTypeCqlNameParser.parse( ~[cassandra-driver-core-3.0.1-shaded.jar:na]
        at ~[cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.SchemaParser.buildTables( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.SchemaParser.buildKeyspaces( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.SchemaParser.refresh( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.ControlConnection.refreshSchema( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.ControlConnection.tryConnect( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.ControlConnection.reconnectInternal( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.ControlConnection.connect( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.Cluster$Manager.init( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.Cluster.init( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.Cluster.connectAsync( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.Cluster.connectAsync( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at com.datastax.driver.core.Cluster.connect( [cassandra-driver-core-3.0.1-shaded.jar:na]
        at org.apache.cassandra.utils.NativeSSTableLoaderClient.init( [apache-cassandra-3.11.3.jar:3.11.3]
10 |1000

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

laxmikant.hcl_32751 avatar image laxmikant.hcl_32751 commented ·

is your issue resolved? Have you tried with cassandra-driver-core-3.3.1.jar

0 Likes 0 ·
tyuen_144153 avatar image tyuen_144153 laxmikant.hcl_32751 commented ·

this is still an issue. it has not resolved.

0 Likes 0 ·
Erick Ramirez avatar image
Erick Ramirez answered

Apologies that your question got buried in the backlog. I've finally managed to circle back and I've been working on a possible fix for you. Let me document the details here for posterity.


Tools in Cassandra 3.x cannot parse the schema of tables which have columns of CQL type duration.


The CQL duration type was added in Cassandra 3.10 (CASSANDRA-11873) to support queries with a filter based on a time interval, for example:

SELECT ... FROM ... WHERE pk = ? AND reading_time < now() - 2h

Support for the duration type was added to the drivers including the Java driver 3.2.0 (JAVA-1347). However, Cassandra 3.11 ships with an older shaded version of the Java driver which doesn't have support for the duration type:



Please test this procedure and let me know how it goes.

Step 1 - Download a newer version of the Java driver from Maven in the same 3.x family.

For example, download cassandra-driver-core-3.10.0-shaded.jar from cassandra-driver-core 3.10.0 on Maven.

Step 2 - On the sstableloader node, replace the old JAR with cassandra-driver-core-3.10.0-shaded.jar.

Step 3 - Attempt to load the data again with sstableloader.


I have logged CASSANDRA-16005 and recommended we update the Java driver that is shipped with Cassandra 3.11.

Note the issue does not apply to Cassandra 4.0+ since it ships with a version of the Java driver that includes JAVA-1347. Cheers!

10 |1000

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

laxmikant.hcl_32751 avatar image
laxmikant.hcl_32751 answered tyuen_144153 commented

Regarding duration datatype error , you need to use cassandra-driver-core version is 3.2.0 or higher ( Ref:

1 comment 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.

tyuen_144153 avatar image tyuen_144153 commented ·

hi, do you any info on how to upgrade the Cassandra's cassandra-driver-core-3.0.1-shaded.jar to be 3.2.0 or higher? The Cassandra version is 3.11.5

0 Likes 0 ·