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

Fixes for COUNT(DISTINCT...) with DistinctPrefixFilter and indexes

    XMLWordPrintableJSON

    Details

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

      Description

      It turns out that PHOENIX-2965 has some bugs with indexes:

      1. COUNT(DISTINCT <indexed column>) does not use the DistinctPrefixFilter
      2. Once an index is created COUNT(DISTINCT <pk-prefix>) is no longer using the DistinctPrefixFilter

      This jira fixes both issues.

      Was:
      Currently the optimization in PHOENIX-258 is not used for DISTINCT index scans. We should add that as well.

        Attachments

        1. 3005-v2.txt
          11 kB
          Lars Hofhansl
        2. 3005-wip-v1.txt
          13 kB
          Lars Hofhansl
        3. PHOENIX-3005_v1.patch
          4 kB
          James Taylor

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: