[ https://issues.apache.org/jira/browse/CASSANDRA-17425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17508787#comment-17508787 ]
Andres de la Peña commented on CASSANDRA-17425: ----------------------------------------------- Agree, that patch was able to do things like: {code:java} CREATE TABLE IF NOT EXISTS t (k int PRIMARY KEY, s set<int>); INSERT INTO t (k, s) VALUES (1, {1, 2}) USING TIMESTAMP 100 AND TTL 10000; UPDATE t USING TIMESTAMP 200 AND TTL 20000 SET s += {3} WHERE k=1; SELECT s[2..], WRITETIME(s[2..]), TTL(s[2..]) FROM t; s[2..] | writetime(s[2..]) | ttl(s[2..]) --------+-------------------+---------------- {2, 3} | [100, 200] | [10000, 20000] {code} I also think that doing MaxWritetime on top of CASSANDRA-8877 would be the easier and most flexible approach. > Add new CQL function maxWritetime > --------------------------------- > > Key: CASSANDRA-17425 > URL: https://issues.apache.org/jira/browse/CASSANDRA-17425 > Project: Cassandra > Issue Type: Improvement > Components: CQL/Syntax > Reporter: Yifan Cai > Assignee: Yifan Cai > Priority: Normal > > The function "writetime" does not support multi-cell types, e.g. collections > and UDT. It would be useful to enable querying the latest modified timestamp > of a column value. > I'd like to propose to add a new function named "maxWritetime", which returns > the largest timestamp amongst the cells. When being applied to the single > cell types, it returns the same result as "writetime". -- This message was sent by Atlassian Jira (v8.20.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org