phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Hyde (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-3993) Make use of DATETIME_PLUS operator in calcite for arithmetics on DATE and TIME
Date Wed, 05 Jul 2017 23:13:00 GMT

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

Julian Hyde commented on PHOENIX-3993:
--------------------------------------

There is an open case for this, CALCITE-304 which covers DATE and could also cover TIMESTAMP.

I'm not sure what the behavior should be when adding an integer to a TIME value. I'm pretty
sure that Oracle would not add milliseconds.

> Make use of DATETIME_PLUS operator in calcite for arithmetics on DATE and TIME
> ------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3993
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3993
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Rajeshbabu Chintaguntla
>            Assignee: Rajeshbabu Chintaguntla
>              Labels: calcite, calcite-compat-change
>
> Syntax of arithmetics on DATE or TIME type are different in calcite but in phoenix we
can use + and - for the same. For example
> {noformat}
> date '2014-02-11' + interval '2' day
> {noformat}
> So any arithmetics on date or time should replace with it. We need to add it as compatibility
change so added calcite-compat-change flag to it.
> Wdyt [~jamestaylor] [~julianhyde] [~maryannxue]?
> FYI [~ankit@apache.org].



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message