Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-258 Use skip scan when SELECT DISTINCT on leading row key column(s)
  3. PHOENIX-2965

Use DistinctPrefixFilter logic for COUNT(DISTINCT ...) and COUNT(...) GROUP BY

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.8.0
    • Labels:
      None

      Description

      Parent uses skip scanning to optimize DISTINCT and certain GROUP BY operations along the row key.
      COUNT queries are optimized differently, could be sped up significantly as well.

      James Taylor, I might need to help into where COUNT(DISTINCT) queries are planned and optimized.

        Attachments

        1. PHOENIX-2965_wip.patch
          1 kB
          James Taylor
        2. 2965-v9.txt
          10 kB
          Lars Hofhansl
        3. 2965-v8.txt
          10 kB
          Lars Hofhansl
        4. 2965-v7.txt
          11 kB
          Lars Hofhansl
        5. 2965-v6.txt
          23 kB
          Lars Hofhansl
        6. 2965-v5.txt
          23 kB
          Lars Hofhansl
        7. 2965-v4.txt
          22 kB
          Lars Hofhansl
        8. 2965-v3.txt
          14 kB
          Lars Hofhansl
        9. 2965-v2.txt
          14 kB
          Lars Hofhansl
        10. 2965-v14.txt
          15 kB
          Lars Hofhansl
        11. 2965-v13.txt
          12 kB
          Lars Hofhansl
        12. 2965-v12.txt
          13 kB
          Lars Hofhansl
        13. 2965-v11.txt
          12 kB
          Lars Hofhansl
        14. 2965-v10.txt
          11 kB
          Lars Hofhansl
        15. 2965.txt
          13 kB
          Lars Hofhansl

          Issue Links

            Activity

              People

              • Assignee:
                lhofhansl Lars Hofhansl
                Reporter:
                lhofhansl Lars Hofhansl
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: