[HIVE-9792] Support interval type in expressions/predicates

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Component/s: Types
• Assignee: Jason Dere
• Reporter: Jason Dere
• Created: 26/Feb/15 01:55
• Updated: 27/Nov/16 08:32
• Resolved: 19/Mar/15 19:06

Description

Provide partial support for the interval year-month/interval day-time types in Hive. Intervals will be usable in expressions/predicates/joins:

  select birthdate + interval '30-0' year to month as thirtieth_birthday
  from table
  where (current_timestamp - ts1 < interval '3 0:0:0' day to second)

This stops short of adding making the interval types usable as a storable column type.

Issue Links

• depends upon: HIVE-9690 Refactoring for non-numeric arithmetic operations
• is related to: HIVE-13557 Make interval keyword optional while specifying DAY in interval arithmetic
• links to: https://reviews.apache.org/r/31696/