InvalidQueryException: Frozen nested collections are not yet supported
looks like frozen nested collection are not supported on AWS keyspaces.
Is there any documentation about this issue anywhere?
I could not find it in the AWS keyspaces - Apache cassandra compatibility notes.
Hey alextk, sorry to hear that you could not find the docs. We will continue to close gaps in supported apis/types. The following page list the current supported types.
Could you share your model for the table and your queries?
What is the suggested alternative from AWS keyspaces instead of Frozen? If I am not wrong, avoiding Frozen leads to enormous tombstone which makes sense in my use case where the whole collection data set is updated at once and not single item in the list. Someone, can throw more light on this?
Amazon Keyspaces does not have the same performance tradeoffs for working with collections. Customers can change individual items in a collection or replace the entire collection without creating tombstones and degrading performance. Customers can expect single digit millisecond operations on row access.
depending on the collection type you can create a high carnality key so the structure gets flattened.
to flattened structure
Alternatively, If you are replacing the entire collection on every update, then a blob will work in a similar way.
Update queries are returning Consistency level errorsasked 2 years ago
Will Multi-Table queries be supported with PartiQL + DynamoDB?asked 2 months ago
Deploying StackSets to OUs with nested OUsasked 2 months ago
Getting InvalidSsmlException For Valid SSML (Neural voices only)asked a year ago
Redshift Spectrum: no way to glance at tables with nested dataasked 3 years ago
AWS Rekognition validation error while adding faces to collectionasked 3 years ago
Is it possible to create Transmit Gateway attachment to ipv6 only subnet?Accepted Answerasked 5 months ago
Why is Austria's TLD (.at) still not supported on Route53?asked 2 months ago
Arbitrary upstream repositories: on the roadmap?asked 5 months ago
InvalidQueryException: Frozen nested collections are not yet supportedAccepted Answerasked a year ago