Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-9534 incorrect result set for query that projects a windowed aggregate
  3. HIVE-13453

Support ORDER BY and windowing clause in partitioning clause with distinct function

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

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.3.0
    • Component/s: PTF-Windowing
    • Labels:
      None

      Description

      Current distinct function on partitioning doesn't support order by and windowing clause due to performance reason. Explore an efficient way to support that.

        Attachments

        1. HIVE-13453.1.patch
          39 kB
          Aihua Xu
        2. HIVE-13453.2.patch
          39 kB
          Aihua Xu
        3. HIVE-13453.3.patch
          39 kB
          Aihua Xu
        4. HIVE-13453.4.patch
          46 kB
          Aihua Xu

          Activity

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

            People

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment