cassandra-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Tolbert (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CASSANDRA-11936) Add support for + and - operations on dates
Date Fri, 13 Jan 2017 22:50:26 GMT

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

Andy Tolbert commented on CASSANDRA-11936:
------------------------------------------

A couple questions about this from experimenting with the branch:

1. Should it also work for timeuuid?
2. Does {{WHERE reading_time < now() - 2h}} work yet or will that be in another ticket?
 The now() function is documented as generating a timeuuid, although maybe it's contextual
by type?  When I try it I get an error {{the '-' operation is not supported between now()
and 2h}}.



> Add support for + and - operations on dates
> -------------------------------------------
>
>                 Key: CASSANDRA-11936
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11936
>             Project: Cassandra
>          Issue Type: Sub-task
>          Components: CQL
>            Reporter: Benjamin Lerer
>            Assignee: Benjamin Lerer
>             Fix For: 3.x
>
>
> For time series it can be interesting to allow queries with {{WHERE}} clause like: {{...
WHERE reading_time < now() - 2h}}
> In order to do that we need to add support for: {{+}} and {{-}} operation with date.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message