[jira] [Created] (PHOENIX-2754) Add INTERVAL type

["Nick Dimiduk (JIRA)" <ji...@apache.org>]

Nick Dimiduk created PHOENIX-2754:
-------------------------------------

             Summary: Add INTERVAL type
                 Key: PHOENIX-2754
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2754
             Project: Phoenix
          Issue Type: Improvement
            Reporter: Nick Dimiduk


We need support for an {{INTERVAL}} datatype. This is a pretty wide feature-gap for anyone doing temporal processing with Phoenix. For example, [Oracle Interval Literals|https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm#i38598], [Postgres Interval Type|http://www.postgresql.org/docs/9.1/static/datatype-datetime.html].

In the mean time, arithmetic between {{DATE}} and {{TIME}} types with numeric values appears to work on units of days, so

{noformat}
> select current_date(), current_date() - 7;
+---------------------------------+---------------------------------+
| DATE '2016-03-09 17:17:58.412'  | DATE '2016-03-02 17:17:58.412'  |
+---------------------------------+---------------------------------+
| 2016-03-09 17:17:58.412         | 2016-03-02 17:17:58.412         |
+---------------------------------+---------------------------------+
{noformat}

and

{noformat}
> select current_date(), current_date() - (4.0/24);
+---------------------------------+---------------------------------+
| DATE '2016-03-09 17:18:19.221'  | DATE '2016-03-09 13:18:19.221'  |
+---------------------------------+---------------------------------+
| 2016-03-09 17:18:19.221         | 2016-03-09 13:18:19.221         |
+---------------------------------+---------------------------------+
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)