[ 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 [~an...@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 [~an...@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 [~an...@apache.org]. -- This message was sent by Atlassian JIRA (v6.4.14#64029)