[PHOENIX-3993] Make use of DATETIME_PLUS operator in calcite for arithmetics on DATE and TIME

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: calcite calcite-compat-change
• Assignee: Rajeshbabu Chintaguntla
• Reporter: Rajeshbabu Chintaguntla
• Created: 05/Jul/17 07:15
• Updated: 05/Jul/17 23:12

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

date '2014-02-11' + interval '2' day

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 James R. Taylor Julian Hyde Wei Xue?
FYI Ankit Singhal.