Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 3.0.0
    • Component/s: None
    • Labels:

      Description

      select * from (select * from foo order by c asc) bar order by c desc;

      in hive sorts the data set twice. The optimizer should probably remove any order by/sort by in the sub query unless you use 'limit '. Could even go so far as barring it at the semantic level.

        Attachments

        1. HIVE-6348.1.patch
          3 kB
          Rui Li
        2. HIVE-6348.2.patch
          3 kB
          Rui Li
        3. HIVE-6348.3.patch
          4 kB
          Rui Li
        4. HIVE-6348.4.patch
          508 kB
          Rui Li

          Issue Links

            Activity

              People

              • Assignee:
                lirui Rui Li
                Reporter:
                hagleitn Gunther Hagleitner
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: