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

Extensions to RS dedup: execute with different column order and sorting direction if possible

    XMLWordPrintableJSON

    Details

      Description

      Pointed out by Gopal Vijayaraghavan.

      RS dedup should kick in for these cases, avoiding an additional shuffle stage.

      select state, city, sum(sales) from table
      group by state, city
      order by state, city
      limit 10;
      
      select state, city, sum(sales) from table
      group by city, state
      order by state, city
      limit 10;
      
      select state, city, sum(sales) from table
      group by city, state
      order by state desc, city
      limit 10;
      

        Attachments

        1. HIVE-13982.patch
          30 kB
          Jesus Camacho Rodriguez
        2. HIVE-13982.8.patch
          581 kB
          Jesus Camacho Rodriguez
        3. HIVE-13982.7.patch
          590 kB
          Jesus Camacho Rodriguez
        4. HIVE-13982.6.patch
          588 kB
          Jesus Camacho Rodriguez
        5. HIVE-13982.5.patch
          595 kB
          Jesus Camacho Rodriguez
        6. HIVE-13982.4.patch
          193 kB
          Jesus Camacho Rodriguez
        7. HIVE-13982.3.patch
          125 kB
          Jesus Camacho Rodriguez
        8. HIVE-13982.2.patch
          52 kB
          Jesus Camacho Rodriguez

          Issue Links

            Activity

              People

              • Assignee:
                jcamachorodriguez Jesus Camacho Rodriguez
                Reporter:
                jcamachorodriguez Jesus Camacho Rodriguez
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: