[
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 [[email protected]].
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 [[email protected]].
> 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 [[email protected]].
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
