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

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    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

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              kgyrtkirk Zoltan Haindrich Assign to me
              Reporter:
              ashutoshc Ashutosh Chauhan

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment