Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5021 Add Interval data type
  3. HIVE-9792

Support interval type in expressions/predicates

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.2.0
    • Types
    • None

    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.

      Attachments

        1. HIVE-9792.1.patch
          299 kB
          Jason Dere
        2. HIVE-9792.2.patch
          299 kB
          Jason Dere
        3. HIVE-9792.3.patch
          301 kB
          Jason Dere
        4. HIVE-9792.4.patch
          303 kB
          Jason Dere
        5. HIVE-9792.5.patch
          303 kB
          Jason Dere
        6. HIVE-9792.6.patch
          302 kB
          Jason Dere
        7. HIVE-9792.7.patch
          300 kB
          Jason Dere

        Issue Links

          depends upon

          Sub-task - The sub-task of the issue HIVE-9690 Refactoring for non-numeric arithmetic operations

          • Major - Major loss of function.
          • Closed
          is related to

          Sub-task - The sub-task of the issue HIVE-13557 Make interval keyword optional while specifying DAY in interval arithmetic

          • Major - Major loss of function.
          • Closed
          links to

          Web Link https://reviews.apache.org/r/31696/

          Activity

            People

              jdere Jason Dere
              jdere Jason Dere
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: