[CASSANDRA-5313] provide a cardinality function for collection types ( CQL3 )

• Type: Improvement
• Status: Open
• Priority: Normal
• Resolution: Unresolved
• Component/s: Legacy/CQL
• Labels: cql
• Assignee: Unassigned
• Reporter: Ahmet AKYOL
• Created: 05/Mar/13 10:46
• Updated: 16/Apr/19 09:32

Description

Currently , cql3 doesn't provide a cardinality function for collection types. It'll be great to have one:

select content, cardinality(like_set),cardinality(dislike_set) from comments where id=?;

or size as keyword

select content, size(like_set),size(dislike_set) from comments where id=?;

Something similar in SQL is cardinality of nested tables .

Issue Links

• is duplicated by: CASSANDRA-7230 Add a size() function to return the number of elements in a collection