Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-14382

Improve the Functionality of Reverse FOR Statement

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.0
    • Component/s: hpl/sql
    • Labels:
      None
    • Flags:
      Patch

      Description

      According to SQL Standards, Reverse FOR Statement should be like this:-

      FOR index IN Optional[Reverse] Lower_Bound Upper_Bound

      but in hive it is like this :-
      FOR index IN Optional[Reverse] Upper_Bound Lower_Bound

      so i m just trying to improve the functionality for Reverse FOR Statement

      REFERNCES :- https://docs.oracle.com/cloud/latest/db112/LNPLS/for_loop_statement.htm#LNPLS1536

        Attachments

        1. HIVE-14382.1.patch
          2 kB
          Akash Sethi
        2. HIVE-14382.1-branch-2.1.patch
          2 kB
          Akash Sethi

          Activity

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

            People

              Dates

              • Created:
                Updated:
                Resolved:

              Time Tracking

              Estimated:
              Original Estimate - 0.5h
              0.5h
              Remaining:
              Remaining Estimate - 0.5h
              0.5h
              Logged:
              Time Spent - Not Specified
              Not Specified

                Issue deployment