Agfdhyk

I have a springboot application which I hooked up with cassandra. I am trying to create a map inside a map but getting the below exception. Seems to me that even though I use @FrozenValue, it is still sending the cal without the keyword frozen

Error

Caused by: org.springframework.data.cassandra.CassandraInvalidQueryException: Query; CQL [CREATE TABLE IF NOT EXISTS assessmentsubmissionentity (studentid text, assessmentid text, values map<text, map<text, text>>, PRIMARY KEY ((studentid, assessmentid)));]; Non-frozen collections are not allowed inside collections: map<text, map<text, text>>; nested exception is com.datastax.driver.core.exceptions.InvalidQueryException: Non-frozen collections are not allowed inside collections: map<text, map<text, text>>

    at org.springframework.data.cassandra.core.cql.CassandraExceptionTranslator.translate(CassandraExceptionTranslator.java:139) ~[spring-data-cassandra-2.1.2.RELEASE.jar:2.1.2.RELEASE]

    at org.springframework.data.cassandra.core.cql.CassandraAccessor.translate(CassandraAccessor.java:334) ~[spring-data-cassandra-2.1.2.RELEASE.jar:2.1.2.RELEASE]

Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: Non-frozen collections are not allowed inside collections: map<text, map<text, text>>

    at com.datastax.driver.core.exceptions.InvalidQueryException.copy(InvalidQueryException.java:49) ~[cassandra-driver-core-3.6.0.jar:na]

Code

@Table

@Getter

@Setter

@NoArgsConstructor

@AllArgsConstructor

public class AssessmentSubmissionEntity implements Serializable {



    @PrimaryKeyColumn(type = PrimaryKeyType.PARTITIONED)

    private String studentId;



    @PrimaryKeyColumn(type = PrimaryKeyType.PARTITIONED)

    private String assessmentId;



    @FrozenValue

    @Column

    private Map <String, Map<String, String>> values;



    @Override

    public boolean equals(Object o) {

        if (this == o) return true;

        if (o == null || getClass() != o.getClass()) return false;

        AssessmentSubmissionEntity that = (AssessmentSubmissionEntity) o;

        return Objects.equals(studentId, that.studentId) &&

                Objects.equals(assessmentId, that.assessmentId) &&

                Objects.equals(values, that.values);

    }



    @Override

    public int hashCode() {



        return Objects.hash(studentId, assessmentId, values);

    }

}

Maven

<dependency>

            <groupId>org.springframework.boot</groupId>

            <artifactId>spring-boot-starter-data-cassandra</artifactId>

            <exclusions>

                <exclusion>

                    <groupId>com.datastax.cassandra</groupId>

                    <artifactId>cassandra-driver-core</artifactId>

                </exclusion>

            </exclusions>

        </dependency>

        <dependency>

            <groupId>com.datastax.cassandra</groupId>

            <artifactId>cassandra-driver-core</artifactId>

        </dependency>

        <dependency>

            <groupId>com.datastax.cassandra</groupId>

            <artifactId>cassandra-driver-mapping</artifactId>

        </dependency>

It's a problem with Spring Data for Cassandra - they don't have mapping for frozen collections. See DATACASS-465 in their JIRA - it was filed more than year ago, but there is no progress on it...

I think that only solution is to use Object Mapper from the DataStax's Java driver, or manage your tables via CQL.