cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Ellis (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-4217) Easy access to column timestamps (and maybe ttl) during queries
Date Thu, 03 May 2012 16:28:51 GMT

    [ 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

        

Mime
View raw message