[jira] [Commented] (CASSANDRA-4217) Easy access to column timestamps (and maybe ttl) during queries

["Jonathan Ellis (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-4217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13267558#comment-13267558 ] 

Jonathan Ellis commented on CASSANDRA-4217:
-------------------------------------------

Good idea.  I'd also note as additional motivation that even though we return timestamps now in the Thrift api, there's no way for SQL-oriented drivers to expose it.

The only wrinkle is that "timestamp" is the name of a SQL datatype...  is there an alternative function name we could use?  timestampof(value), maybe?
                
> Easy access to column timestamps (and maybe ttl) during queries
> ---------------------------------------------------------------
>
>                 Key: CASSANDRA-4217
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-4217
>             Project: Cassandra
>          Issue Type: Sub-task
>          Components: API
>    Affects Versions: 1.1.0
>            Reporter: Sylvain Lebresne
>            Assignee: Sylvain Lebresne
>              Labels: cql3
>             Fix For: 1.1.1
>
>
> It would be interesting to allow accessing the timestamp/ttl of a column though some syntax like
> {noformat}
> SELECT key, value, timestamp(value) FROM foo;
> {noformat}
> and the same for ttl.
> I'll note that currently timestamp and ttl are returned in the resultset because it includes thrift Column object, but adding such syntax would make our future protocol potentially simpler as we wouldn't then have to care about timestamps explicitely (and more compact in general as we would only return timestamps when asked)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira