Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-258

Use skip scan when SELECT DISTINCT on leading row key column(s)

    Details

    • Type: Task
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.8.0
    • Labels:
      None
    • old issue number:
      127

      Description

      create table(a varchar(32) not null, date date not null constraint pk primary key(a,date))

      [["PLAN"],["CLIENT PARALLEL 94-WAY FULL SCAN OVER foo"],[" SERVER AGGREGATE INTO ORDERED DISTINCT ROWS BY [a]"],["CLIENT MERGE SORT"]]

      We should skip scan.

        Attachments

        1. 258.txt
          5 kB
          Lars Hofhansl
        2. 258-v1.txt
          6 kB
          Lars Hofhansl
        3. 258-v10.txt
          29 kB
          Lars Hofhansl
        4. 258-v11.txt
          32 kB
          Lars Hofhansl
        5. 258-v12.txt
          38 kB
          Lars Hofhansl
        6. 258-v13.txt
          41 kB
          Lars Hofhansl
        7. 258-v14.txt
          45 kB
          Lars Hofhansl
        8. 258-v15.txt
          44 kB
          Lars Hofhansl
        9. 258-v16.txt
          45 kB
          Lars Hofhansl
        10. 258-v17.txt
          44 kB
          Lars Hofhansl
        11. 258-v2.txt
          8 kB
          Lars Hofhansl
        12. 258-v3.txt
          9 kB
          Lars Hofhansl
        13. 258-v4.txt
          17 kB
          Lars Hofhansl
        14. 258-v5.txt
          28 kB
          Lars Hofhansl
        15. 258-v6.txt
          27 kB
          Lars Hofhansl
        16. 258-v7.txt
          26 kB
          Lars Hofhansl
        17. 258-v8.txt
          28 kB
          Lars Hofhansl
        18. 258-v9.txt
          28 kB
          Lars Hofhansl
        19. 258-WIP.txt
          5 kB
          Lars Hofhansl
        20. DistinctFixedPrefixFilter.java
          2 kB
          Lars Hofhansl
        21. in-clause.png
          7 kB
          Nick Dimiduk

          Issue Links

            Activity

              People

              • Assignee:
                lhofhansl Lars Hofhansl
                Reporter:
                ryang-sfdc ryang-sfdc
              • Votes:
                0 Vote for this issue
                Watchers:
                10 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: