Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13554 [Umbrella] SQL:2011 compliance
  3. HIVE-13557

Make interval keyword optional while specifying DAY in interval arithmetic

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.1.0
    • Fix Version/s: 2.2.0
    • Component/s: Types
    • Labels:
      None

      Description

      Currently we support expressions like:

      WHERE SOLD_DATE BETWEEN ((DATE('2000-01-31'))  - INTERVAL '30' DAY) AND DATE('2000-01-31')
      

      We should support:

      WHERE SOLD_DATE BETWEEN ((DATE('2000-01-31')) + (-30) DAY) AND DATE('2000-01-31')
      

        Attachments

        1. HIVE-13557.1.patch
          23 kB
          Zoltan Haindrich
        2. HIVE-13557.1.patch
          23 kB
          Zoltan Haindrich
        3. HIVE-13557.1.patch
          23 kB
          Zoltan Haindrich
        4. HIVE-13557.2.patch
          49 kB
          Zoltan Haindrich
        5. HIVE-13557.3.patch
          50 kB
          Zoltan Haindrich
        6. HIVE-13557.3.patch
          50 kB
          Zoltan Haindrich

          Issue Links

            Activity

              People

              • Assignee:
                kgyrtkirk Zoltan Haindrich
                Reporter:
                ashutoshc Ashutosh Chauhan
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: