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

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.8.0
    • None
    • 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.

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

      Attachments

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

        Issue Links

          Activity

            People

              larsh Lars Hofhansl
              larsh Lars Hofhansl
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: