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

Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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.

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

      Attachments

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

        Issue Links

        relates to

        Bug - A problem which impairs or prevents the functions of the product. PHOENIX-2974 SELECT COUNT(DISTINCT c1, c2,...) throws NPE

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Open

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment