phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Taylor (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 14:19:00 GMT

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

James Taylor commented on PHOENIX-3993:
---------------------------------------

Does Calcite have a compatibility mode to work like Oracle such that date arithmetic works
without using the interval keyword, [~julianhyde]?

This would be a pretty big breaking change and not something we can change the unit tests
for since Phoenix doesn't support the interval keyword.

> 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