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

DISTINCT keyword is dropped by the parser for windowing

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.1.0
    • 2.0.1, 2.1.0
    • None
    • None

    Description

      To reproduce, the following query can be used:

      select distinct first_value(t) over ( partition by si order by i, b ) from over10k limit 100;

      The distinct keyword is ignored and duplicates are produced.

      Attachments

        1. HIVE-13242.patch
          32 kB
          jcamachorodriguez

        Issue Links

        is related to

        Bug - A problem which impairs or prevents the functions of the product. HIVE-4662 first_value can't have more than one order by column

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. HIVE-14959 Fix DISTINCT with windowing when CBO is enabled/disabled

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

        Web Link RB link

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            jcamacho Jesús Camacho Rodríguez Assign to me
            jcamacho Jesús Camacho Rodríguez
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment