phoenix-dev mailing list archives

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

     [ https://issues.apache.org/jira/browse/PHOENIX-3993?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Rajeshbabu Chintaguntla updated PHOENIX-3993:
---------------------------------------------
    Description: 
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].

  was:
Syntax of arithmetics on DATE or TIME type are different in calcite. 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].


> 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