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

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

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Resolution: Fixed
    • None
    • 4.8.0
    • None
    • None
    • 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. DistinctFixedPrefixFilter.java
          2 kB
          Lars Hofhansl
        3. in-clause.png
          7 kB
          Nick Dimiduk
        4. 258-WIP.txt
          5 kB
          Lars Hofhansl
        5. 258-v1.txt
          6 kB
          Lars Hofhansl
        6. 258-v2.txt
          8 kB
          Lars Hofhansl
        7. 258-v3.txt
          9 kB
          Lars Hofhansl
        8. 258-v4.txt
          17 kB
          Lars Hofhansl
        9. 258-v5.txt
          28 kB
          Lars Hofhansl
        10. 258-v6.txt
          27 kB
          Lars Hofhansl
        11. 258-v7.txt
          26 kB
          Lars Hofhansl
        12. 258-v8.txt
          28 kB
          Lars Hofhansl
        13. 258-v9.txt
          28 kB
          Lars Hofhansl
        14. 258-v10.txt
          29 kB
          Lars Hofhansl
        15. 258-v11.txt
          32 kB
          Lars Hofhansl
        16. 258-v12.txt
          38 kB
          Lars Hofhansl
        17. 258-v13.txt
          41 kB
          Lars Hofhansl
        18. 258-v14.txt
          45 kB
          Lars Hofhansl
        19. 258-v15.txt
          44 kB
          Lars Hofhansl
        20. 258-v16.txt
          45 kB
          Lars Hofhansl
        21. 258-v17.txt
          44 kB
          Lars Hofhansl

        Issue Links

          Activity

            People

              larsh Lars Hofhansl
              ryang-sfdc ryang-sfdc
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: