[
https://issues.apache.org/jira/browse/CASSANDRA-9312?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14698605#comment-14698605
]
Sylvain Lebresne commented on CASSANDRA-9312:
---------------------------------------------
I'll note that my preference regarding syntax for this is simply to start
allowing the {{writeTime}} and {{ttl}} methods on primary key columns (it will
thus return the same value for every PK column of the same row).
The alternative would be to have a special syntax that include all the PK
columns, like:
{{noformat}}
SELECT writeTime(k, t1, t2), ttl(k, t1, t2) WHERE ...;
{{noformat}}
but it doesn't feel really better to me and is more special-casy and slightly
more complex from an implementation point of view.
> Provide a way to retrieve the write time of a CQL row
> -----------------------------------------------------
>
> Key: CASSANDRA-9312
> URL: https://issues.apache.org/jira/browse/CASSANDRA-9312
> Project: Cassandra
> Issue Type: New Feature
> Components: API
> Reporter: Nicolas Favre-Felix
> Assignee: Sylvain Lebresne
> Fix For: 2.2.x
>
>
> There is currently no way to retrieve the "writetime" of a CQL row. This is
> an issue for tables in which all dimensions are part of the primary key.
> Since Cassandra already stores a cell for the CQL row, it would make sense to
> provide a way to read its timestamp. This feature would be consistent with
> the concept of a row as an entity containing a number of optional columns,
> but able to exist on its own.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)