Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.2.0
    • Component/s: Types
    • Labels:
      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.7.patch
          300 kB
          Jason Dere
        2. HIVE-9792.6.patch
          302 kB
          Jason Dere
        3. HIVE-9792.5.patch
          303 kB
          Jason Dere
        4. HIVE-9792.4.patch
          303 kB
          Jason Dere
        5. HIVE-9792.3.patch
          301 kB
          Jason Dere
        6. HIVE-9792.2.patch
          299 kB
          Jason Dere
        7. HIVE-9792.1.patch
          299 kB
          Jason Dere

          Issue Links

            Activity

              People

              • Assignee:
                jdere Jason Dere
                Reporter:
                jdere Jason Dere
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: