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

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 4.8.0
    • None
    • 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. PHOENIX-3005_v1.patch
          4 kB
          James R. Taylor
        2. 3005-wip-v1.txt
          13 kB
          Lars Hofhansl
        3. 3005-v2.txt
          11 kB
          Lars Hofhansl

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: