Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-5096

Local index region pruning is not working as expected.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.1.0, 4.16.0
    • Labels:
      None

      Description

      The pruning of local indexes should do the following:

      • Use the local index
      • Reduce the number of regions based on filters on the table's primary key (i.e. WHERE conditions including prefixes of the primary key)

      Instead it looks like in order for this to work the needed PK column need to be included in the local index itself, changing the sort order of the local index.

      I'll provide some examples in the comments.

      James Taylor, Thomas D'Silva, Vincent Poon, Josh Elser, Geoffrey Jacoby

        Attachments

        1. 5096-4.x-HBase-1.5.txt
          1 kB
          Lars Hofhansl
        2. 5096-4.x-HBase-1.5-v2.txt
          3 kB
          Lars Hofhansl
        3. 5096-4.x-HBase-1.5-v3.txt
          4 kB
          Lars Hofhansl

          Issue Links

            Activity

              People

              • Assignee:
                larsh Lars Hofhansl
                Reporter:
                larsh Lars Hofhansl
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: